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

[mustish1 via AccessMonster.com]

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.

 

[Marshall Barton]

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;

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.