Help with linked server query

I have two tables in a linked server that I am trying to accomplish the following:

Server is called Medic, schema is informix, catalog is v001
table names are findet and findhdr

1) join indices (patkey and invno)
2) distinct count (finhdr.patid)
3) sum currency(findet.amount)
4) within a date range(findet.ar_date)
5) having specific criteria (findet.proccode = "99201 thru 99205")

Any help is greatly appreciated!

JTremember,in SQL Server,Microsoft using four-section to describe the database object.It's [server].[database].[owner].[object_name].
example,linkserver Access,table name is MyTable,u must write [server_access]...[MyTable].
link server oracle,user is scott,table is employee,u must write [server_oracle].[].[scott].[employee].

I have no knowledge about informix.But I think u can know how to describe ur table according my introduction,Right?|||Originally posted by enhydraboy
remember,in SQL Server,Microsoft using four-section to describe the database object.It's [server].[database].[owner].[object_name].
example,linkserver Access,table name is MyTable,u must write [server_access]...[MyTable].
link server oracle,user is scott,table is employee,u must write [server_oracle].[].[scott].[employee].

I have no knowledge about informix.But I think u can know how to describe ur table according my introduction,Right?

Thank you for the response. It is not what I was looking for. If anyone else can help, I would appreciate it.