title: php mysql 4 tables join
body: <p>I have 4 tables, in table's <code>'tbl_Order'</code> has single record of each  cusotmer.
  in table's <code>'tbl_OrderDetail'</code> there are more then 1 Services (records) of each customer. 
  in table's  <code>'tbl_services'</code>  there are more then 10  pre-define services.
  inch table's  <code>'tbl_users'</code>    there are customer's basic information.</p>
  
  <p>my question is :  how I can fetch  data  by each customer using PHP with MySql. My tables details are below:</p>
  
  <pre><code>tbl_Order:   Order_ID,Order_Type,Order_Date,Time,Customer_ID,Booking_Type,Booking_Status,Order_No,Car_No,Booking_Date
  
  tbl_OrderDetail: ID,Order_ID,Service_ID     
  
  tbl_services :  Service_ID,S_Name,S_Price
  
  tbl_users : Customer_ID ,User_Name
  </code></pre>