Can I do something like this in a BAQ:
SELECT JobHead.Jobnum,
(SELECT Top 1 * FROM erp.JobProd jp where jp.jobnum = JobHead.JobNum),
JobHead.DueDate,
JobHead
etc
etc
FROM JobHead
Can I do something like this in a BAQ:
SELECT JobHead.Jobnum,
(SELECT Top 1 * FROM erp.JobProd jp where jp.jobnum = JobHead.JobNum),
JobHead.DueDate,
JobHead
etc
etc
FROM JobHead
Yes, this should be just a basic subquery in the BAQ designer.