All right. So i have child, parent, activity and register table and i want know how much money a parent will pay for his child if the child have 1 or more activities.
So i came out with this code:
CONCAT_WS (' ', parent_title, parent_fname, parent_sname) AS 'Parent/Carer Name',
CONCAT('£', act_price) AS Amount,
COUNT(*) AS 'Nr of Act.'
FROM Activity A, Parent P, Child C, Register R
WHERE C.parent_id = P.parent_id AND
C.child_id = R.child_id AND
A.act_id = R.act_id
GROUP BY P.parent_id
and see atachment for result.
the thing is in the Amount column the value are all £0.00
any ideea anyone?
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...
Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot ...