tabel_A,tabel_B,tabel_C,tabel_D 四张表查询方法:
select D.device_uuid,D.track_switch from tabel_A A INNER JOIN tabel_B B ON A.device_uuid=B.device_uuid INNER JOIN tabel_C C ON A.device_uuid=C.device_uuid INNER JOIN tabel_D D ON A.device_uuid=D.device_uuid;
tabel_A,tabel_B,tabel_C,tabel_D 四张表查询方法:
select D.device_uuid,D.track_switch from tabel_A A INNER JOIN tabel_B B ON A.device_uuid=B.device_uuid INNER JOIN tabel_C C ON A.device_uuid=C.device_uuid INNER JOIN tabel_D D ON A.device_uuid=D.device_uuid;