| Subject | SQL Syntax 2 databases |
|---|---|
| Author | sasidhardoc |
| Post date | 2005-04-21T01:31:52Z |
I need to select fields using an SQL query spanning two different
data bases
SELECT FIRST_DB.TABLE.FIELD1
FROM FIRST_DB.TABLE
WHERE
FIRST_DB.TABLE.FIELD2 = SECOND_DB.TABLE.FIELD5
But I get an error? Please help..
data bases
SELECT FIRST_DB.TABLE.FIELD1
FROM FIRST_DB.TABLE
WHERE
FIRST_DB.TABLE.FIELD2 = SECOND_DB.TABLE.FIELD5
But I get an error? Please help..