How not to repeat the same column ?

hi i'm a beginner in mysql and this is my 1st visit 2 this forum wish u can help me
i have 2 tables
the 1st containe column emp_num (primary)
the 2nd contains column emp_num (foreign)
i want 2 show all information in the 2 tables about employees without repeating the same column (emp_num)

select * from workers , inf where workers.emp_num = inf.emp_num;

the column emp_num appears twice in the result table
what's the solution

the most simple way would be to write the specific columns you wish instead of everything. for example, if the inf have an id, a name and the emp_num, the select would be:

select workers.*, inf.id, inf.name from workers, inf where workers.emp_num = inf.emp_num

thanks alot
and we can do this

select workers.* , inf.event , inf.email from workers
inner join inf on workers.emp_num = inf.emp_num;

but the solution you posted is easier i think
thanks again