Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Jan 14 2008 6:12 AM	Permanent Link
"nes.elevatesoft.com"	Hello, I have to join two tables in differnt directories. e.g.: T1 in DIR1 T2 in DIR2 SELECT * FROM T1 t1 JOIN T2 t2 on t1.id = t2.id this works fine when both tables in the same directory. Can anyone help with the syntax to solve this? Knut
Mon, Jan 14 2008 6:53 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Knut Use the fully qualified path names eg >SELECT * >FROM 'C:\Dir1\T1' t1 >JOIN 'D:\dir2\T2' t2 on t1.id = t2.id Roy Lambert
Tue, Jan 15 2008 9:35 AM	Permanent Link
"nes.elevatesoft.com"	Thanks a lot for the hint, using " instead of ' around the TableNames and it works fine. Knut Lambert "Roy Lambert" <roy.lambert@skynet.co.uk> schrieb im Newsbeitrag news:30432A1C-2836-44CE-ADCF-56608D5AD592@news.elevatesoft.com... > Knut > > Use the fully qualified path names eg > > >>SELECT * >>FROM 'C:\Dir1\T1' t1 >>JOIN 'D:\dir2\T2' t2 on t1.id = t2.id > > > Roy Lambert