Using tables in different databases

[jdassani]

Hi,

I have a select query which does a join on 2 tables. These two tables are in different databases.
1) What should be the connection string using sql92?
2) What should be the SQL statement for the same?

Can I also execute an Update Statement when the tables are in different databases.

Thanx a lot in anticipation
Jeetendra

 

[Serj HAMMER]

tables from different DB

Yes, You can execute an Update Statement when the tables are in different databases.
If the tables has equal names then You should use DB-Name prefix:

UPDATE database1.table.field database2.table.field.

Otherwise You may update it as, like it placed in one database.
About SQL-92 I don't know...