sser; 'nigel wood'; [EMAIL PROTECTED]
> Subject: Re: Is it possible to use an "optional field"?
>
>
> Your query converted to using left joins:
> SELECT DISTINCT Questions.QuestionID, Questions.Question,
> Experts.ExpertFullName, Category.CategoryName, Q
>
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
Assuming that there is a one-to-one relationship between the tables on the
FunctionID (meaning there is only one entry in Functions for each
FunctionID), then...
SELECT Names.NameID, Names.Name, Names.FunctionID, Functions.FunctionName
FROM Names LEFT JOIN Functions ON (Names.FunctionID=Function
-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 ha
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