Query ข้อมูล ครัวเรือน

SELECT tb_house_registration.house_registration_id, tb_house_registration.community_id, tb_house_registration.province_id, tb_house_registration.amphur_id, tb_house_registration.district_id, tb_house_registration.moo, tb_house_registration.village_name, tb_house_registration.community_name, tb_house_registration.house_number, tb_house_registration.house_code, tb_house_registration.house_number_nearby, tb_house_registration.family_member, province.province_name, amphures.name_th AS amphures_name, districts.name_th AS districts_name, tb_house_registration.created_at, tb_house_registration.created_by, tb_login.id, tb_login.surname, tb_login.username, tb_login.name` FROM tb_house_registration LEFT JOIN districts ON tb_house_registration.district_id = districts.id LEFT JOIN province ON tb_house_registration.province_id = province.province_id LEFT JOIN amphures ON tb_house_registration.amphur_id = amphures.id LEFT JOIN tb_login ON tb_house_registration.created_by = tb_login.id WHERE tb_house_registration.province_id = '45' AND tb_house_registration.amphur_id = '668'

`