Data from two tables - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Data from two tables

Message

30/04/2003 15:59:44

Sergey Berezniker
New York, États-Unis

30/04/2003 15:55:18

Steven Dyke
Safran Seats USA
Texas, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Data from two tables

Divers

Thread ID:

00783329

Message ID:

00783406

Vues:

>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--

Répondre

Fil

Voir

Click here to load this message in the networking platform