That works perfectly. Thank you.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 2:42 PM
To: Eric Kilgore; [EMAIL PROTECTED]
Subject: Re: left join on more than one field
At 12:29 -0700 6/28/03, Eric Kilgore wrote:
>Anyone know how to perf
Anyone know how to perform a left join by more than one field?
I have several tables I'm working with. An example query is like this:
SELECT tbl1.Name, tbl1.Location, tbl1.Case, tbl1.Class, tbl1.Type,
tbl3.Identity, tbl2.FileDate, tbl2.Status
FROM tbl2, tbl1 LEFT JOIN tbl3 ON tbl1.Case = tbl3.Ca
