Tag:Selling price

  • How to query temporary table with PDO in PHP project?


    SQL1 CREATE TEMPORARY TABLE r_js SELECT b.agenname30 AS agenname, fhsname30 AS fhsname, b.loc_id, b.locname50 AS locname, a.customter, SPACE( 100 ) AS js_desc, SPACE( 20 ) AS js_date1, SPACE( 20 ) AS js_date2, SPACE( 20 ) AS js_amt, SPACE( 20 ) AS js_rate FROM v_saleonline a, v_locat b WHERE a.loc_id = b.loc_id AND a.inv_date BETWEEN ‘2020-08-01’ […]