SQL Query won't run in Dreamweaver
I'm posting this sql query to see if anyone can't help me out. I can't figure out what I'm doing incorrectly and I need to get this to work to finish a project. For some reason when I try to run the query in Dreamweaver it won't run on the page. When I test it in the recordset window it works perfectly and returns the correct data. I write sql using Navicat and the sql query works perfectly in Navicat. When I try to access the dreamweaver recordset I get a 1064 error. Any help would be appreciated.
Select (Select Count(item_id) FROM sales WHERE total_sale < 10) / (Select Count(item_id)) FROM sales