我想同时从不同字段的2个不同表中获取两个不同的值

Question

I have 2 table name as p_order and p_customer.

I have to fetch the values of P_order_no and P_customer_name from the respective fields

<?php
      $wherecat = "`p_order_status` = 'active'";
      $catsql =$general->GetRows('*' ,'p_order' ,$wherecat);
      $catRes = mysql_num_rows($catsql);
       <p><muted></muted><br/>
          <a href="#">customer name =</a>order no =<br/>
       </p>
 ?>

Answer 1

Try this demo query :-

select * from p_order inner join p_customer on 
p_order.customer_id=p_customer.id where p_order_status='active'