车辆表 t_car

id
name

已售 t_had_sale

id

下架 t_off_sale

id

车辆信息、是否已售、是否下架

  1. SELECT
  2. t1.*,
  3. t2.id,
  4. t3.id
  5. FROM
  6. t_car t1
  7. LEFT JOIN t_had_sale t2 ON t1.id = t2.id
  8. LEFT JOIN t_off_sale t3 ON t1.id = t3.id

文档更新时间: 2019-06-26 18:53