I would like to count the number of balls given to the children and would like to link four different tables as mentioned below.
Tables are 1) Ball 2) lu_ball_disp 3) CN122_balls 4) Balldetail
Jul 26 '12 at 05:51 AM
Aug 01 '12 at 11:58 AM
A better way to seek swift help is to post the DDLs of the table, some test data and the desired output.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Jul 26 '12 at 05:51 AM
Seen: 299 times
Last Updated: Aug 01 '12 at 11:58 AM
how to count count child rows
query for count
count users for past 7 days
Summary of Transaction
How to count based on multiple columns
Count text and numeric records
Multiple counts with multiple tables.
How to get the customer Count based on the Users & userType from the History Table
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.