Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with Select SQL
Message
De
12/03/2003 19:55:17
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
12/03/2003 08:39:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00764238
Message ID:
00765214
Vues:
16
>Thanks for your answer.
>Now, I need that the query shows me all records of table1 , have or not linked records in table2 or table3.
>For example :
>
>
>table1.id table1.nombre table2.desc table3.id
>---------------------------------------------------------
>1 Pedro casa 1001
>1 Pedro auto 1001
>2 Juan casa 1003
>2 Juan yate 1003
>3 Alberto auto 1005
>3 Alberto casa 1005
>4 Luis casa
>5 Hugo
>6 Miguel yate 1009
>7 Andres
>8 Carlos casa 1017

Change your joýn type. ie:

...from t1 left join t2 on t1.id = t2.t1id ;
left join t3 on t1.id = t3.t1id...
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform