Copy คำสั่งด้านล่าง ไปรัน ใน Navicat แต่ต้อง อัพเดท title_code ใหม่ก่อน
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