Thanks Michale. The problem is solved.:) Michael Satterwhite <[EMAIL PROTECTED]> wrote:
>-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote: >> 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? > >This is a UNION query. For example: > > Select name as Joined_column from Staff where company_id = 1 > UNION > Select owner as Joined_column from company where company_id = 1; > >-----BEGIN PGP SIGNATURE----- >Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) > >iD8DBQE/Gv6YjeziQOokQnARAmoLAKCf6NSmFaLG5foQYZtbHpeGuUZJOgCgrINR >Q1SFb1eu7DUXAIV/44savs8= >=4h+/ >-----END PGP SIGNATURE----- > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
