php - mysql inner join 3 tables

Solution:

  $tours = mysql_query("SELECT * FROM 
  tours t INNER JOIN tour_property_array  p ON  
  t.tour_id = p.tour_id INNER JOIN tour_prices tp  ON  
  p.tour_id = tp.tour_id  AND t.tour_status='Aktif' 
  WHERE t.tour_category_id=".$category_id." AND t.date_month ='".$date."' AND  p.tour_propert_id=".$propert_id." ");
Copy code

replace it with

$tours = mysql_query("SELECT * FROM tours t INNER JOIN tour_property_array p ON
        t.tour_id = p.tour_id INNER JOIN tour_prices tp ON p.tour_id = tp.tour_id
        AND t.tour_status='Aktif' WHERE t.tour_category_id='$category_id' AND
         t.date_month ='$date' AND p.tour_propert_id='$propert_id' ");
Copy code

Solution:

Try this one

SELECT 
    *
FROM
    tours t
        INNER JOIN
    tour_property_array p ON t.tour_id = p.tour_id
        INNER JOIN
    tour_prices tp ON p.tour_id = tp.tour_id
        AND t.tour_status = 'Aktif'
WHERE
    t.tour_category_id = '.$category_id.'
        AND t.date_month = '".$date."'
        AND p.tour_propert_id = '".$propert_id."';
Copy code

Solution:

use this query ..
select *
from
    tableA a
        inner join
    tableB b
        on a.common = b.common
        inner join 
    TableC c
        on b.common = c.common
Copy code

Solution:

You are Giving a condition in Join Move it to Where Clause.

SELECT 
     *
      FROM
           tours t
                INNER JOIN
                        tour_property_array p ON t.tour_id = p.tour_id
                INNER JOIN
                        tour_prices tp ON p.tour_id = tp.tour_id

      WHERE
             t.tour_category_id = '.$category_id.'
             AND t.tour_status = 'Aktif'
             AND t.date_month = '".$date."'
             AND p.tour_propert_id = '".$propert_id."';
Copy code