Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data from two tables
Message
From
30/04/2003 15:59:44
Sergey Berezniker
New York, United States
 
 
To
30/04/2003 15:55:18
Steven Dyke
Safran Seats USA
Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Data from two tables
Miscellaneous
Thread ID:
00783329
Message ID:
00783406
Views:
22
>Now I only get the record that is in both tables 'B'. I need all the records in t1 and t2.

LEFT JOIN should take care about that. Can you post your select? Most likely WHERE condition filters out the rest of records.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform