Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select with the second DB
Message
From
30/01/2022 11:12:58
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01683370
Message ID:
01683393
Views:
39
>>IIRC, try this:
>>
>>select column1 from Table1 where column2 in (select T2.pk_field from " + cSecondDb + ".Table2 as t2 where 
>>t2.field3 = 'xyz'
>>
>
>Thank you. The important thing is that you used cSecondDb only once, in the FROM clause. This answers my question.

That's because I'm lazy :).

Theoretically, it may work with a longer syntax, but I never tried that.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform