Hi all,
I have 3 tables: attendee (holds attendee info), transactions (1 to Many table that holds the attendees' transactions) and attendee_license (1 to many table that holds attendees' license numbers).
i need to write a query that left joins attendee to transactions (for our purposes, attendee NATURAL LEFT JOIN transactions) and also left joins attendee to attendee_license (attendee NATURAL LEFT JOIN attendee_license).
I can't do a simple "attendee NATURAL LEFT JOIN transactions NATURAL LEFT JOIN attendee_license", because as far as i can tell, that is the equivalent of "attendee NATURAL LEFT JOIN transactions" and "transactions NATURAL LEFT JOIN attendee_license". That's bad, because for those entries where there are no transactions, we also get no attendee_license info either.
Anyone know a remedy? i hope this wasn't too confusing....
-Phil
I have 3 tables: attendee (holds attendee info), transactions (1 to Many table that holds the attendees' transactions) and attendee_license (1 to many table that holds attendees' license numbers).
i need to write a query that left joins attendee to transactions (for our purposes, attendee NATURAL LEFT JOIN transactions) and also left joins attendee to attendee_license (attendee NATURAL LEFT JOIN attendee_license).
I can't do a simple "attendee NATURAL LEFT JOIN transactions NATURAL LEFT JOIN attendee_license", because as far as i can tell, that is the equivalent of "attendee NATURAL LEFT JOIN transactions" and "transactions NATURAL LEFT JOIN attendee_license". That's bad, because for those entries where there are no transactions, we also get no attendee_license info either.
Anyone know a remedy? i hope this wasn't too confusing....
-Phil