SQL查询的问题????????????

多表查询：

Select tableA.a,b,c

From tableA,tableB

Where tableA.a=tableB.a

当两表有相同列名时，需在元素前加表名 tableA.a 。。。

单表内的模拟多表查询：

Select first.a,second.a

From tableA first,tableA second

Where first.b = second.f

已实现2个表内联接查询，以下是查询语句：
SELECT movies.mov_id AS 影片编号,
movies.mov_name AS 影片名称,movies.mov_number AS 影片数量,
movies.mov_type AS 影片类型,movies.mov_new AS 推荐新片,
movies.mov_pupArea AS 影片出品地,
discs.disc_id AS 影碟编号,discs.disc_state AS 影碟状态,
discs.disc_type AS 影碟类型,discs.disc_number AS 影碟数量,
movies.mov_brief AS 影片简介,discs.disc_remark AS 备注
FROM movies INNER JOIN discs
ON movies.mov_id = discs.mov_id

select
a.corpid,
a.userid,
a.inid,
b.列
c.列
from a,b,c
where
a.corpid=b.corpid(+) and a.userid=b.userid(+)
and
a.corpid=c.corpid(+) and a.Inid=c.Inid(+);