I use the DW Query mode in all of the master lists and search screens in my app... it works like a charm. But, I have a new requirement in one of my master windows to show the number of linked documents, which is stored in a different table. So my basic query changed from:
SELECT c.cal_procedure , c.description , c.active , c.create_user , c.create_date , c.edit_user , c.edit_date FROM cal_procedure c
SELECT c.cal_procedure , c.description , c.active , c.create_user , c.create_date , c.edit_user , c.edit_date , (SELECT COUNT(*) FROM cal_procedure_doc where cal_procedure = c.cal_procedure) AS cpd FROM cal_procedure c
Now I get an error every time I enter a query parameter. The error is "Incorrect Syntax near the keyword 'and' ". Is there a better way to construct the SQL statement? I've tried a couple other ways with no luck.