how to write this qry into one ?cmd =new SqlCommand("select noofproducts from tbl_sales select *from tbl_empname w ...