sql,两个表同时显示

来源：百度知道 编辑：UC知道 时间：2024/05/16 03:13:58
表1,price表
sn,1,2,3,4,5,6
表2,usage表
sn,1,2,3,4,5,6
两个表字段是一样, 值不一样,一个是price ,一个是usage,
求SQL语句查询出price.sn=usage.sn时的显示结果如下,
price 1,2,3,4,5,6
usage 1,2,3,4,5,6
price 1,2,3,4,5,6
usage 1,2,3,4,5,6
也就是符合条件的记录每一个表显示一行.然后是下一个记录

SELECT “字段列表”
FROM price
WHERE EXISTS (SELECT * FROM usage WHERE (price.sn = usage.sn))
UNION ALL
SELECT “字段列表”
FROM usage
WHERE EXISTS (SELECT * FROM price WHERE (price.sn = usage.sn))
ORDER BY sn

不清楚 具体的 需求 用 union all 试试看

SELECT *
FROM price INNER JOIN usage ON price.sn = usage.sn

使用内连接 inner join