Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    31

    Unanswered: 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!


    JT

  2. #2
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    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?

  3. #3
    Join Date
    Apr 2004
    Posts
    31
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •