and (c.field='1' and c.listid='1' and c.fcont='A1')
and (c.field='1' and c.listid='2' and c.fcont='A2')
你确定这样的条件吗?好像不可能吧,两个条件不会同时满足的
and (c.field='1' and c.listid='2' and c.fcont='A2')
你确定这样的条件吗?好像不可能吧,两个条件不会同时满足的
select * from
A inner join B
on A.bosid = B.bosid
inner join C
on B.bosid = C.bosid and B.field = C.field
inner join D
on C.bosid = D.bosid and C.field = D.field
where 可以加上你的条件了
例如 where title = 'title1' and field = '1' and list = '1'