This is an old revision of the document!
SELECT
Joins
- example: we want all records from table “parcels,” and only corresponding fields from table “owners” where the owner_id matches:
- select parcels.id, parcels.area, parcels.book, parcels.map, parcels.parcel, parcels.owner_id, owners.owner, owners.address, owners.city, owners.state, owners.zip, owners.phone, owners.phone_verified, owners.comments, parcels.`alternate owner id`, parcels.acres, parcels.`recorder number`, parcels.`purchase price`, parcels.`purchase date`, parcels.`in house parcel id`, parcels.`tax status`, parcels.comment, parcels.`shared assessor parcels` from owners right join parcels on parcels.owner_id=owners.owner_id order by parcels.area, parcels.`in house parcel id` asc;