mrknowledge Posted January 26, 2007 Share Posted January 26, 2007 Table A has a number that ID's an entry in Table B. Table B then has a list of names with the id. Is there a way to 'alphabatize' Table A with Table B's names? Quote Link to comment https://forums.phpfreaks.com/topic/35854-combining-2-tables/ Share on other sites More sharing options...
artacus Posted January 26, 2007 Share Posted January 26, 2007 SELECT a.*FROM aJOIN b ON a.id = b.a_idORDER BY b.name Quote Link to comment https://forums.phpfreaks.com/topic/35854-combining-2-tables/#findComment-169997 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.