var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Join Between two different databases
I have the following Statement but I can't seem to get the join working correctly;
R_MACHINE is a foreign key and Machinenumber is primary.
INSERT INTO TTOMODULE.dbo.Restrictions2 SELECT * FROM WOLVERHAMPTON.dbo.Restrictions2 WHERE TTOMODULE.dbo.Machines.MACHINENUMBER = WOLVERHAMPTON.dbo.Restrictions2.R_MACHINE
Any help or advice would be great.
what's your error message?
The multi-part identifier "TTOMODULE.dbo.Machines.MACHINENUMBER" could not be bound.
SELECT * FROM DBNAME1..TABLENAME a
INNER JOIN DBNAME2..TABLENAME b ON a.LINKFIELD = b.LINKFIELD