Cant display duplicate column name?

Hi,

Encounter another problem...

I have 2 tables which stores employees worktime record.
One of the tables stores record on the current month and the another table will store record from the previous month.

When i do this query...

SELECT a.emp_id, a.emp_name, a.in_time, a.out_time, a.date, b.in_time, b.out_time, b.date
FROM worktime_current a, worktime_previous b
WHERE a.emp_id = b.emp_id;

I got this error msg
ORA-00957: duplicate column name

What is wrong the query?? Cant it display a column that have the same name but from different tables???

How to modify it so that the query can work?

Thanks

--------------------------
regards,
YuLing

If you select columns with the same name from different tables, you need to assign a column alias for those columns:

This query suppose to work fine. If you are using this query to CREATE a new table or in INSERT clause, it will give you error message. Check your query again.

Thank you...

The code work just fine as i only wants it to display the the time out, not creating a new table.

But just for some additional knowledge, incase i need to CREATE a new table in the future...what should i do if the new table that i wanted to create contain two columns that have the same column name. Do i rename either one the 2 column first before i can create the new table?? Or is there an easier way to do it??

Thanks

Ooo and btw is there any difference between
WHERE a.emp_id = b.emp_id

and

WHERE b.emp_id = a.emp_id


----------------------
YuLing