get all the records from LastValidTech even one of the condition dont match

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mustish1 - 29 Sep 2006 03:28 GMT

Hi: I try to print data from LastValidTech even one of the condition
Join/Where dont match. But it shows empty record.

SELECT
LastValidTech.Account1,
LastValidTech.LstVldTech,
tech_id.TECHCONT,
tech_id.CORP,
LastValidTech.ReportID
FROM LastValidTech LEFT JOIN tech_id
ON LastValidTech.LstVldTech = tech_id.TECH
WHERE (((tech_id.CORP)=Val(Left([LastValidTech].[Account1],5))))
GROUP BY
LastValidTech.Account1,
LastValidTech.LstVldTech,
tech_id.TECHCONT,
tech_id.CORP,
LastValidTech.ReportID;

Thanks.

Reply to this Message

Marshall Barton - 29 Sep 2006 05:37 GMT

>Hi: I try to print data from LastValidTech even one of the condition
>Join/Where dont match. But it shows empty record.
[quoted text clipped - 14 lines]
>tech_id.CORP,
>LastValidTech.ReportID;

I think the problem is bevause you are using a LEFT JOIN
instead of an INNER JOIN

Why are you using a GROUP BY clause? Without an aggregate
function, the only thing it accomplishes is to prevent
duplicate output records, which the purpose of the DISTINCT
predicate.

Signature

Marsh
MVP [MS Access]

Reply to this Message