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
>
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar