Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with innerjoin
Message
De
16/04/1999 07:51:21
Christian Bellavance
Université du Québec à Hull
Hull, Québec, Canada
 
 
À
16/04/1999 03:58:02
Information générale
Forum:
Visual Basic
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00208891
Message ID:
00208922
Vues:
19
Would should write de select statement as follow:

select * from FeedDatabase inner join BpDatabase on FeedDatabase.[fieldname1] = BpDatabase.[fieldname1]

On the ON part of your select statement you can put as many parameter you need but they have to exist in both table.

To make your select statement more readable you should use aliases, so the statement should looks like this:

select * from FeedDatabase FD inner join BpDatabase BD on FD.[fieldname1] = BD.[fieldname1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform