Posted by Unknown on May 02, 2013 Get link Facebook Twitter Pinterest Email Other Apps query to display sales report from from two tables using join Sales Person Tablesalesperson Sales Report Tablesalesorder Result Query SELECT count(so.P_Id) as No_of_Sales, sp.* FROM `salesorder` as so,`salesperson` as sp WHERE so.P_Id=sp.P_Id group by sp.P_Id Comments
Comments
Post a Comment