[MS_AccessPros] Field not meeting the join criteria

 

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 (1)

Recent Activity:

• New Members 6
• New Files 2

Visit Your Group

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

.

__,_._,___