Tuesday, July 24, 2018

Join to Tables with From and Where

SELECT dt_tda_master_2.id,dt_accomodation_master.business_name,dt_accomodation_master.accomodation_reference FROM `dt_accomodation_master`,`dt_tda_master_2`
WHERE dt_accomodation_master.accomodation_id = dt_tda_master_2.accommodation_id