How to return row if a calculated field is blank in BAQ

Epicor ERP 10
,
1

Hi,

I have a BAQ that is using a calculated field to get the first transaction date for labor “min(LaborDtl.ClockInDate)”, and another calculated field for first material transaction “min(PartTran.TranDate)”, but when I run the baq it wont return rows when 1 of the above calculated field is blank, for example JOB123 has no labor transactions but has material transactions it won return on my BAQ, but if both have data then it returns.

How can I get it to return if 1 of the calculated fields is blank?

2

You need a full outer join between the two tables.

image