No. Some mail servers (qmail for sure) have the user auth section seperated
from the piece that accepts mail from the internet. As long as the mail is
for the correct domain, it will accept it, and passes it to a seperate
program that checks for the user and either bounces or delivers the mail.
transactions.CourseID='$Course_ID' is not the same as the three part join
that you have in that query. Are your sure your other two joins aren't
restricting the query?
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:09 AM
To: [EMAIL P
as far as the Course
table is concerned and there is also data displayed (or used in calculations
from the other two tables which do not necessarily relate just to these
records.
Hope this clarifies rather than confuses.
George
- Original Message -----
From: "Kevin Bucknum" &l
You need to look up LEFT JOIN in the documention of the database you are
using.
>
> "Andy" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi there,
> >
> > I do have a sql statement where I could need some help on.
> >
> > There are 3 tables: provinces
