Merging cells in Sql

[SeGamysa]

Hi I just need some sample code
I have 1 table in sql.
what I need to do is join column a and b together and c and d together into a new table from lets say table emp.
At this point I can't remember how to do that.
If any one can give me a quick sample or a link it would be greatly appreiated.
Thank you.

[pyro]

Not exactly positive if this is what you need, but have a look at UNION: http://www.mysql.com/doc/en/UNION.html

If that's not it maybe JOIN: http://www.mysql.com/doc/en/JOIN.html