AAA表为主表,BBB表为AAA副表,通过AAA.AID=BBB.AID关联,CCC表也为AAA表副表,通过AAA.AID = CCC.AID关联:
希望查询 AAA表中id等于BBB。id或者CCC。id的文章
select AAA.id,title,BBB.newstext as lzh2,CCC.newstext as lzh1 from AAA,BBB,CCC where (AAA.id='$id' and AAA.id=BBB.id and AAA.classid='$classid') or (AAA.id='$id' andAAA.id=CCC.id and AAA.classid='$classid') "
|