Your query converted to using left joins:
SELECT DISTINCT Questions.QuestionID, Questions.Question,
Experts.ExpertFullName, Category.CategoryName, Questions.Shows,
Questions.Views
FROM Questions
LEFT JOIN Experts ON (Questions.ExpertID = Experts.ExpertID)
LEFT JOIN Category ON (Questions.CategoryID = Category.CategoryID)
WHERE Questions.OnHold = 2 GROUP BY Questions.QuestionID
That will grab each record in the Questions table, and return data in
Experts and Categories *IF* it exists, otherwise nulls.
----- Original Message -----
From: "Roy Nasser" <[EMAIL PROTECTED]>
To: "'nigel wood'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 28, 2001 3:18 PM
Subject: RE: Is it possible to use an "optional field"?
> I took a look at the manual, but I am a bit unsure of how this would be
done
> in a multi-table wuery, such as the one below... if anyone can help,
greatly
> appreciated! :)
>
> SELECT DISTINCT Questions.QuestionID, Questions.Question,
> Experts.ExpertFullName, Category.CategoryName, Questions.Shows,
> Questions.Views FROM Questions, Experts, Category WHERE
> (Questions.ClientID='15') AND (Questions.ExpertID = Experts.ExpertID) AND
> (Questions.CategoryID = Category.CategoryID) AND Questions.OnHold=2 GROUP
BY
> Questions.QuestionID;
>
> Thank you for all help!
>
> As usual, please Reply All! :)
>
>
> > -----Original Message-----
> > From: nigel wood [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, March 28, 2001 8:16 PM
> > To: Roy Nasser
> > Subject: Re: Is it possible to use an "optional field"?
> >
> >
> > On Wed, 28 Mar 2001, you wrote:
> > > Hi,
> > >
> > > I have two joined tables (three actually, but for an
> > example, 2 is OK)...
> > >
> > > example:
> > >
> > > Names / Function
> > >
> > > Then in names I have NameID, Name, and FunctionID, and in
> > Function table, I
> > > havce FunctionID, and FunctionName...
> > >
> > > therefore, I need to find the Function Name of a Person,
> > through their
> > > name... - simple engouh until this point...
> > >
> > > SELECT Names.NameID, Names.Name, Names.FunctionID,
> > Functions.FunctionName
> > > WHERE (Functions.FunctionID = Names.FunctionID)...
> > >
> > > However, in some cases, Names.FunctionID might be empty, or
> > not match
> > > anything in Functions table, and in this case I want the
> > > Functions.FunctionName to show up as null, or empty...
> > >
> > > I have been told that in MS Sql, the query would be
> > something like the
> > > above, with the where like this: WHERE
> > > (Names.FunctionID=*Functions.FunctionID)
> > >
> > > This did not work in MySQL 3.23.30... Can you help?
> > >
> > > Thanks!
> > >
> > > PS: Please reply directly to me... (Reply All)... Thanks! :)
> >
> > Look up LEFT JOIN in the manual & get a copy of PaulBois's
> > 'MySQL' book
> >
> > Nigel
> >
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
