MySQL Forums
Forum List  »  MySQL Query Browser

Join two tables
Posted by: Alper KIGITZI
Date: August 12, 2011 10:33AM

table1

id fullname
1 a
2 b

table2

id years isPaid
1 2009 1
1 2010 0
1 2011 0
2 2009 1
2 2010 1
2 2011 1

what quary i need to do that

id fullname 2009 2010 2011
1 a 1 0 0
2 b 1 1 1

thanks



Edited 1 time(s). Last edit at 08/12/2011 10:33AM by Alper KIGITZI.

Options: ReplyQuote


Subject
Written By
Posted
Join two tables
August 12, 2011 10:33AM
August 18, 2011 07:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.