Information générale
Catégorie:
Codage, syntaxe et commandes
>I have a main table (schedule) with several (6) look-up tables (location, category, contact, ...).
>
>They are related by key fields (schedule.loc_id -- location.loc_id, etc.) The schedule table does not necessarily have these fields entered (the client wants them optional).
>
>What is the syntax for several outer joins with SELECT? I took a shot at it with the query builder, but it doesn't retrieve the right data either.
Here's one I wrote last night:
select mbr_pk, due_mbr_fk, mbr_snameck, due_date, typ_nameck from ;
Members left outer join Dues on due_mbr_fk == mbr_pk ;
left outer join Types on due_typ_fk == typ_pk ;
order by mbr_snameck
Each field is prefixed by the table name abbreviation. PK stands for primary key; fk for foreign key. A Member can have zero or many Dues and a Dues has a Type.
This will produce .NULL. for due_mbr_fk, due_date and typ_nameck if a Member has no Dues.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement