Howdy, Stranger!

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

Categories

Retrieving data from two different databases

lionblionb Member Posts: 1,688 ✭✭
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

  • lionblionb Member Posts: 1,688 ✭✭
    : 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.