Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help on SQL syntax
Message
De
17/05/1999 17:54:47
Henri Miceli
Sprachcaffe Languages Plus
Frankfurt, Allemagne
 
 
À
14/05/1999 18:06:45
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00219256
Message ID:
00219820
Vues:
16
in this case you might want to make a union clause in your sql statement.
split your sql statement so tha the top part before the union clause retirieves one part of the statement whilst the second sql statement retrieves the second part of the join.

it would go something like this

select * from table1 left outer join table2 ;
on table1.linkfield = table2.linkfield ;
into cursor blabla ;
union select * from table1 left outer join table3 ;
on table1.linkfield = table2.linkfield
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform