Just regular sql at the command level

Okay

any time today is fine

actually its both

1) sum the # XXXXX toys for each child.. whixh is really the same you just worded it differently.

To Clarify. I need the number of toys (the count) for each child. How many toys does each child have

thanks

For the first question:

1: List "All" children and All their toys.

Can you provide he sql which list only the children with toys

2. I am not sure if this is correct ie

select CHILD.Child_name, count(Mapping Table.Toy_ID) From Mapping Table,CHILD where Mapping Table.Child_id=CHILD.Child_id group by Mapping Table.Child_id;

...Mapping Table, CHILD

you have a , after Mapping Table and then begin with the CHILD table do you mean a period .

thank you I have to go to a meeting but as soon as I get back I will review.

Thank you for your help much appreciated

I am sure its fine I wanted to review tommorrow is their a time limit. Meaning is it okay to spend tommorrow reviewing and then sign off. I

I just wanyted o followup on your syntax and your comments...............................

try this

select CHILD.Child_name, Toy.Toy_name From CHILD,Toy, Mapping Table where Mapping Table.Child_id=CHILD.Child_id AND Mapping Table.Toy_id=Toy.Toy_id;

2.
Here select from two tables Mapping Table and CHILD
you want to count the number of toys for each child
so get child name from the child table and number of toys from mapping table for each child and join on child id from mapping table and child table

hope this helps.............................................................

1) You substiute WHERE for ON.

I assume they are the same???

2) You don't use INNER JOIN or OUTER JOIN when writing the SQL pe your comments and Join on child_id from Mapping table ... ir the SQL statement INNER JOIN and OUTER JOIN not necessary?

Okay great.
it would be good to see how different the same sql querys would look for questions 1 - 4 using ON and inner outer and full JOINS

thank you

okay thanks again

Thank you

I just need to confirm that we can wrtite the SQL for question 1 and Question #2 two different ways and get the same output results. Question #3 and #4 should remain the same

Thanks again fro your help

1: List
"All" children and All their toys.
Answer 1A:
SELECT * Child, Toy;

Answer 1B:

SELECT CHILD.Child_name, Toy.Toy_name FROM CHILD, Toy, Mapping Table WHERE Mapping Table, Child_id = CHILD.Child_id AND Mapping Table.Toy_id = Toy.Toy_id;

Answer 1C:

SELECT
CHILD.Child_name, Toy.Toy_name FROM CHILD LEFT OUTER
JOIN Mapping Table ON
CHILD.Child_id INNER JOIN Toy ON Toy.Toy_id = Mapping Table.Toy_id

_____________________________________________________________________

2: : Sum
the # XXXXX Toys for each Child

Anwer 2A:
SELECT
CHILD.Child_name, COUNT(Mapping
Table.Toy_ID)FROM
Mapping Table, CHILD WHERE
Mapping Table.Child_id = CHILD.Child_id GROUP BY Mapping
Table.Child_id;

Answer 2B:

SELECT
CHILD.Child_name, COUNT
(Mapping Table.Toy_ID) FROM
Mapping Table INNER JOIN
CHILD ON Mapping
Table.Child_id = CHILD.Child_id GROUP BY Mapping Table.Child_id;