Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select with the second DB
Message
De
30/01/2022 11:12:58
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01683370
Message ID:
01683393
Vues:
40
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform