Query repeating results and should not
Hey Experts!!
I have a query (below) that is returning results numerous times and shouldn't be. This a very straightforward query.
AED_Master.AED_no is key in the main table
AED_Master.serial_code does not have duplicates
Can someone help?
I have a query (below) that is returning results numerous times and shouldn't be. This a very straightforward query.
AED_Master.AED_no is key in the main table
AED_Master.serial_code does not have duplicates
Can someone help?
SELECT AED_Master.serial_code, AED_Master.placement, Cat_Sub.Subgroup, Models.Model
FROM AED_Master, Client, Cat_Sub, Models
WHERE AED_Master.Model_ID = 26
AND Cat_Sub.Category = "School"
AND Client.CatSub_ID = Cat_Sub.CatSub_ID;
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
it's not "required", you could also use simple WHERE conditions to do the same.
however, writing JOINs will make it much clearer in the query how the tables are related...
however, writing JOINs will make it much clearer in the query how the tables are related...
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER