You can select from one or more tables at once. But you need to use some sort of join between them other wise you will get a cartasian product i.e. all the rows in one table linking with all the tables in another.
So you can use for example
select e.emp_id, d.dept_id from emps e, dept d;
but this wil link all rows in emps with all rows in dept, the more logical solution is
select e.emp_id, d.dept_id from emps e LEFT JOIN dept ON e.dept_id = d.dept_id;
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information