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.