คิวรี่ Owner,land-owner,land

SELECT

land._parcel_code, 

land._dn, 

land.l_type, 

land.rw, 

land.sc, 

land.ln, 

land.sn, 

land.lb, 

land.lp, 

land.moo, 

land.r, 

land.y, 

land.w, 

land.price, 

landused.lu_type, 

landused.u_r, 

landused.u_y, 

landused.u_w, 

landused.owner_used, 

landused.used_by, 

landused.lu_notes, 

title_code.title_type, 

`owner`.prefix, 

`owner`.fname, 

`owner`.lname, 

`owner`.pop_id, 

`owner`.address, 

`owner`.moo, 

`owner`.soi, 

`owner`.road, 

districts.district, 

districts.amphoe, 

districts.province, 

districts.zipcode

FROM

land

INNER JOIN

landused

ON 

land.lid = landused.lid

INNER JOIN

land_owner

ON 

land.lid = land_owner.lid

INNER JOIN

`owner`

ON 

land_owner.owner_id = `owner`.owner_id

INNER JOIN

title_code

ON 

`owner`.prefix = title_code.title_name

INNER JOIN

districts

ON 

`owner`.tambon_id = districts.district_code