表1
ID PK
biao2ID1 FK
biao2ID2 FK
biao2ID3 FK
表2
ID PK
type
怎么查啊，悲剧啊，不知道条件怎么写了
------解决方案--------------------
- SQL code
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 ......