Is thier anyway using the BAQ tool to do a left join/is null type statement? I’m trying to find jobs that are missing all operations - so there would be a record in JOBHEAD with no match in JOBOPER

SELECT Erp.JobHead.JobNum FROM Erp.JobHead LEFT JOIN Erp.JobOper ON Erp.JobHead.JobNum = Erp.JobOper.JobNum WHERE ((Erp.JobOper.JobNum) Is Null);

How can i find records in 1 table with no matching record in 2nd table

Banderson (Brandon Anderson) July 31, 2018, 4:45pm 2

Isn’t that what you asked here?

Topic		Replies	Views
Jobs without method or without JobOper records Epicor ERP 10	4	923	May 5, 2017
BAQ Filter for Null Epicor ERP 10	13	9330	March 10, 2022
BAQ - Where something is NOT in joined table Epicor ERP 10 baq	8	3013	November 22, 2021
BAQ Report - How to Show Job Operations with Zero Transactions Epicor ERP 10 baq , jobs , report-builder , baq-report	2	756	November 21, 2019
Baq not exists Epicor ERP 10 baq	5	1984	May 16, 2019