表1 record 包含 两个 属性 id,time
表2 doubleRecord 包含 5个属性 id,time,rec1,rec2,rec3,rec4要求 连接 两个表,record能与doubleRecord关联起来的就关联起来,关联不起来就就直接查出来,并能够按照时间排序
表2 doubleRecord 包含 5个属性 id,time,rec1,rec2,rec3,rec4要求 连接 两个表,record能与doubleRecord关联起来的就关联起来,关联不起来就就直接查出来,并能够按照时间排序
SELECT * FROM record JOIN doubleRecord ON record.id = doubleRecord.id ORDER BY record.time;
SELECT * FROM record JOIN doubleRecord ON record.id = doubleRecord.id ORDER BY doubleRecord.time;
3楼的代码看起来不错,改一下即可
SELECT * FROM record JOIN doubleRecord ON record.id = doubleRecord.id ORDER BY record.time;
SELECT * FROM doubleRecord JOIN Record ON record.id = doubleRecord.id ORDER BY doubleRecord.time;