If you want to restrict the tuples you get from 'broadcasts' use AND
instead of WHERE.
Cheers
/rudy
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: dinsdag 7 oktober 2003 15:42
To: Wayne Helman
Cc: [EMAIL PROTECTED]
Subject: Re: Multiple Join Issue
Lea
Leave off the 'WHERE e.Game_ID is NULL'
Wayne Helman wrote:
How would one join multiple table and selected all
records from a joined table whether they exist OR not?
I can get the records if they exist in a second table
and I can get the records if they don't exist, but is
there a way to combine