Select A.F1, A.F2, A.F3, B.F1, B.F2, B.F3
From test1.tableA a, test2.tableB B
WHERE A.F4=B.F4

-----Original Message-----
From: Indra Timilsina
[mailto:mssqldba-ezmlmshield-x52526195.[Email address protected]
Sent: Friday, February 24, 2006 11:08 AM
To: LazyDBA Discussion
Subject: creating query from two different database.


Hi there,



I am looking for information on how to create query with tables from two
different databases which are in same server



Like table A is in database TEST1

And table B is in database TEST2



I need to select A.F1, A.F2, A.F3 AND B.F1, B.F2, B.F3 WHERE A.F4=B.F4





Thanks.





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

_________________________________________________________________________

This message and any attachments may be confidential or privileged and are for the exclusive use of the intended recipient. If you are not the addressee or intended recipient, please do not read, copy, use, or disclose this communication to others. If you have received this in error, please notify the sender by replying to this message, and then delete it entirely from your system. Delivery of this message and any attachments to any person other than the intended recipient(s) is not intended in any way to waive confidentiality or a privilege. All personal messages express views only of the sender, which are not to be attributed to Finish Line and/or any of its subsidiaries or affiliates, and may not be copied or distributed without this statement.


MS Sql Server LazyDBA home page