I'm trying to join 2 tables from 2 different databases.
table1 is called "sale" (in "convert" database)
table2 is called "category" (in "propertydb" database)
The matching columns are
s.subcategoryid = c.categoryname
I tried something like this but it doesn't work.
SELECT subcategoryid
FROM sale
WHERE subcategoryid in
(USE propertydb
SELECT
subcategoryID,
className,
categoryName
FROM
category)
What's the correct syntax to join these two tables?
Thank you.
Alex
table1 is called "sale" (in "convert" database)
table2 is called "category" (in "propertydb" database)
The matching columns are
s.subcategoryid = c.categoryname
I tried something like this but it doesn't work.
SELECT subcategoryid
FROM sale
WHERE subcategoryid in
(USE propertydb
SELECT
subcategoryID,
className,
categoryName
FROM
category)
What's the correct syntax to join these two tables?
Thank you.
Alex