主题：[求助]查询表SQL语句

很努力去看了，你的意思是不是，我根据 A B 和 A1 三个值，得到最后一张图的数据？

怎么感觉好绕哦。

select {表C}.编号, {表C}.名称编号1, {表C}.名称编号2, {表C}.表B编号
    from (select * from (select * from {表C} inner join {表B} on {表C}.表B编号 = {表B}.编号) As tb1
        inner join {表A} on tb1.表A编号1 = {表A}.编号) as tb2
                inner join {表A} on tb2.表A编号2 = {表A}.编号
where tb2.名称编号1 = 'A1' and ({表A}.名称 = 'A' or {表A}.名称 = 'B')

好像下面这样才正确

select {表C}.编号, {表C}.名称编号1, {表C}.名称编号2, {表C}.表B编号
    from (select * from (select * from {表C} inner join {表B} on {表C}.表B编号 = {表B}.编号) As tb1
        inner join {表A} on tb1.表A编号1 = {表A}.编号) as tb2
                inner join {表A} on tb2.表A编号2 = {表A}.编号
where tb2.名称编号1 = 'A1'
    and ({表A}.名称 = 'A' or {表A}.名称 = 'B') and (tb2.名称 = 'A' or tb2.名称 = 'B')