如果一个表里面有3个外键都是连接到同一张表,该怎么查啊!
表1
ID PK
biao2ID1 FK
biao2ID2 FK
biao2ID3 FK
表2
ID PK
type
怎么查啊,悲剧啊,不知道条件怎么写了
[解决办法]
select * from [表1] a left join [表2] b on a.biao2ID1 = b.IDleft join [表2] c on a.biao2ID2 = c.IDleft join [表2] d on a.biao2ID3 = d.IDwhere ......