Subquery in the Select statement BAQ Help

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.

2 Likes