Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference between the joins?
Message
From
18/01/2001 13:07:07
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00465231
Message ID:
00465238
Views:
18
>I often hear about an inner, outer, left and right joins. What is the difference in the SQL and in the result sets.
>
>I use "FROM table1, table2 WHERE custno = custno" often and realize it only picks rows from the two tables that match. What is this kind of join called?
>
>Thanks
>
>Brenda
Inner.
Mark
Previous
Reply
Map
View

Click here to load this message in the networking platform