Retrieving data from two different databases

Question about MS SQL Server 2000
I have two Databses DATAB1 and DATAB2. I need to retrieve data from both of them using only one SQL Statement or stored procedure. Something like that
SELECT Name from DATAB1.tblNames.Name, DATAB2.tblNames.Name
WHERE DATAB2.tblNames.OfficialName LIKE '%JON%'

I know it's wrong syntax but I hope you understand my idea.
I need it ASAP and any help/advice will be highly appreciated.

Comments

  • : Question about MS SQL Server 2000
    : I have two Databses DATAB1 and DATAB2. I need to retrieve data from both of them using only one SQL Statement or stored procedure. Something like that
    : SELECT Name from DATAB1.tblNames.Name, DATAB2.tblNames.Name
    : WHERE DATAB2.tblNames.OfficialName LIKE '%JON%'
    :
    : I know it's wrong syntax but I hope you understand my idea.
    : I need it ASAP and any help/advice will be highly appreciated.
    :
    :
    Never mind. I've got it working.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion