也就是复合查询，例句如下

SELECT * FROM table1 n, table2 i WHERE n.itemid = i.itemid