September 22nd, 2013, 10:20 PM
Query help needed.
Need help w/ a join, or multiple table query.
I need to show school id, school name, team name.
What I've tried:
SQL> desc team
SQL> desc school
SQL> select school.school_name, team. team_name
2 where team.school_id=school.school_id
3 from school,team;
September 23rd, 2013, 08:14 AM
You did not received any error message? When you make a post please include the error messages you receive.
In your SQL, FROM should be be placed after SELECT.
when joining tables, you should use the explicit JOIN syntax, instead of the implicit FROM table1,table2, ....
SELECT school.school_id, school.school_name, team.team_name
INNER JOIN team ON team.school_id=school.school_id