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
