BAQ "subquery" help

Hi Tory,

It seems that like me, you would prefer writing SQL yourself. It took me a while to get used to using the BAQ Designer. I don’t have any data in my QuoteOpr table so I couldn’t test it but attached is a simple query to demonstrate how I normally do the subquery in the BAQ Designer. Import it into your system and see if it gives you what you need. You may want to add a Parameter to the Main query if you want to run it for a single Quote.

SubqueryDemo.baq (26.3 KB)