SELECT tm.idesc,tm.tgno,tm.gwt,tm.wt,tm.sdiawt,tm.salemrp,tm.stamp,tm.ssamt FROM my_cart mc LEFT JOIN tg_master tm ON tm.`tgno`= mc.item_tgno LEFT JOIN members m ON m.cpid=mc.cpid WHERE mc.orderno='ROD4' and tm.status = 'IN STOCK'