oracle如何关联两张表进行合并查询?

给表A表B取个别名，然后联合查询： select a.*,b.PUBURL from TableA a,TableB b where a.EQUIPPING like '%001%' or a.EQUIPPING like '%002%' and a.METADOCID = b.DOCTITLE and a.TITLE = b.DOCTITLE;