[MS_AccessPros] Re: Field not meeting the join criteria

 

Does this do what you want?

SELECT tblContact.ContactID, [FirstName] & " " & [LastName] & " " & [Suffix] AS
ContactName
FROM tblContact LEFT JOIN tlkpSuffixes ON tblContact.SuffixID =
tlkpSuffixes.SuffixID;

Paul

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I have this query:
>
> SELECT tblContact.ContactID, [FirstName] & " " & [LastName] & " " & [Suffix] AS ContactName
> FROM tblContact INNER JOIN tlkpSuffixes ON tblContact.SuffixID = tlkpSuffixes.SuffixID;
>
> It is returning nothing because there is no records with a Suffix. How can I work around that and display records that don't have a suffix?
>
> Thanks
>
> Arthur Lorenzini
> Sioux Falls, SD
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 6
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___