Error in Selection Query
select count(a.doc_id) as total,count(b.doc_id) as total1,a.doc_id doc_id from tbl_doc_locations a LEFT JOIN tbl_pvt_practice b ON a.doc_id=b.doc_id where a.doc_id in (193038,194429,187651,187701,190251,190284,193041,,) group by doc_id UNION select count(a.doc_id) as total,count(b.doc_id) as total1,b.doc_id doc_id from tbl_doc_locations a RIGHT JOIN tbl_pvt_practice b ON a.doc_id=b.doc_id where b.doc_id in (193038,194429,187651,187701,190251,190284,193041,,) group by doc_id
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') group by doc_id UNION select count(a.doc_id) as total,count(b.doc_id) as total' at line 1