SQL

• Madhuri-296804

  Grasshopper

  Points: 12

  More actions

  February 2, 2006 at 6:06 am

  #116131

  Hi

  Can I use a SQL in statement using 2 tables from 2 different databases one from Access and the other one from SQL Server.

  select distinct region_id,country_name,country_id from Renewal_Data where region_id in (select region_id from smUsrGrp where userid = '"& suserid & "')

  Here Renewal_Data  table is an Access table and  smUsrGrp is  SQL table.

  Regards

  Madhuri

• Mathew J Kulangara

  SSCommitted

  Points: 1610

  More actions

  February 2, 2006 at 8:36 am

  #618418

  use open row set....

  Here is an example..

  select k.*,x.* FROM

  OPENDATASOURCE

  (

  'MICROSOFT.JET.OLEDB.4.0',

  'DATA SOURCE="x:\LOCATION\X.MDB";

  USER ID=ADMIN;PASSWORD='

  )...TABLE_INACCESS k

  join some_table x

  on x.some_field = k.some_field

  ..or you can make a linked server

  ---

  Mathew J Kulangara
  sqladventures.blogspot.com