mysql join query

 

select * from customer_shipping_address join hub_item_order_request on customer_shipping_address.said=hub_item_order_request.said where hub_item_order_request.hiorid < 49545 AND hub_item_order_request.hiorid >49534


Answer
 

select(‘tbl1.*,tbl2.*’);
from(tbl1.’ a’);
join(tbl2.’ b’,’tbl2.field_name=a.field_name’,’left’);
where(array(‘a.filed_name’=>’value’);
group_by(‘tbl1.field_name’);
order_by(‘tbl2.field_name’,’desc’);




Recent Question