27,578
社区成员
发帖
与我相关
我的任务
分享
SELECT Id,关联编号,Name,BillNo FROM table1
SELECT Id,关联编号,Name,BillNo FROM table2
SELECT Id,关联编号,Name,BillNo FROM table3
SELECT *
FROM ( SELECT a.Id ,
( CASE WHEN b.Id IS NULL THEN a.Name
ELSE b.Name
END ) AS Name ,
( CASE WHEN c.Id IS NOT NULL THEN c.BillNo
WHEN b.Id IS NOT NULL THEN b.BillNo
ELSE a.BillNo
END ) AS BillNo
FROM table1 a
LEFT JOIN table2 b ON a.关联编号 = b.关联编号
LEFT JOIN table3 b ON a.关联编号 = c.关联编号
) t
WHERE t.BillNo = @BillNo
AND t.Name = @Name;