Hello,
I have to join two columns from different tables in a query. Assume that I have two tables:
staff
id company_Id name
1 1 FirstName
2 1 SecondName
3 2 ThirdName
company company_Id owner 1 MyOwnerName 2 SecondOwnerName
Here I need to join the columns staff.name and company.owner from two tables with the name joined_column so I can do order by on them. For example when I query two tables with the company_id = 1 I want to get a resultset like this:
joined_column -------------------- FirstName MyOwnerName SecondName
Any comments?
Thanks in advance.
[sql, query, mysql] --
Veysel Harun Sahin [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]