I think you won't get enough information about joins here. There are several types of joins and things about joins you should know. Try to use google in order to find some resources.
For some reasons you should prefer the ANSI SQL syntax to the "old" style (which uses the join condition in the WHERE clause), but pay attention that your database has to support this standard form of writing joins (e.g. Oracle does not support ANSI SQL joins prior to 9i).
The "old" join style (in this case an inner join) looks like this:
Code:
SELECT e.ename, d.dname
FROM emp e, dept d
WHERE e.deptno = d.deptno;
Here is the same example with an ANSI SQL join:
Code:
SELECT e.ename, d.dname
FROM emp e
JOIN dept d
ON e.deptno = d.deptno;
Best regards
Sven