MySQL Forums
Forum List  »  MySQL Query Browser

help! i need somebody
Posted by: ra meir
Date: November 20, 2010 03:45AM

hi guys!
my teacher gave us an assigmniet in mt college,
i have a table that here name is "coaches", it is a table of all the basketball coaches in the us (its not a real table with real coaches).

the coulums are: 1.coache name 2. year of birth

the question is this : return all 2 coaches that were born in the same year and their year of birth, all cuople must return only once and the date must appere as: (coach1,coach2,year of birth)

now in know i need to do a Cartesian product but i dont know how..
someone can give me a solution?!
10x u guys...
ran

Options: ReplyQuote


Subject
Written By
Posted
help! i need somebody
November 20, 2010 03:45AM


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.