How to correctly use a join in sql queries
I am working on a project that requires me to generate reports from multiple tables, namely:
School
Student
Team
Province
Entry
Language
Game
I want to add data for the records that are related and that were created on a particular day and when i use inner join, i get between 7200 and 19000 but these records are actually not be more than 200, can you please take a look and help me refine the query
Query.txt
Entries-2012-1-13-.xls
School
Student
Team
Province
Entry
Language
Game
I want to add data for the records that are related and that were created on a particular day and when i use inner join, i get between 7200 and 19000 but these records are actually not be more than 200, can you please take a look and help me refine the query
Query.txt
Entries-2012-1-13-.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Michael Carrillo
Did this query work for you?