How can I select from 2 tables in Oracle?

[Angry Coder]

Hello,

The fallowing didn't work for me:

SELECT * FROM AccessLog as a, pr_departments as d WHERE a.lid = d.description;

What;s the problem?

Thank you.

[r937]

define "didn't work"

syntax error?

no syntax error, but no results?

results, but wrong rows?

[Angry Coder]

acullay it worked after trying serveral hours :S

[Karl]

From my experience with Oracle (Was a few years back), it'll have been the AS keyword, as I don't think Oracle supports it for creating aliases, you just simply put the alias name you want after the table name e.g.

SELECT * FROM AccessLog a, pr_departments d WHERE a.lid = d.description;

[Dr John]

Karl is correct. The As keyword in oracle is for renaming / aliasing a column.
e.g. select ename, sal*12 as AnnualPay from emp

replaces sal*12 with AnnualPay as the column heading.