Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
with tables in different Directorys |
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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |