I have 3 tables Camp , Register, Receipt

Camp Register Receipt

camp id Name Category

camp name Camp Name Register No

camp date Reg No


Camp_name and Reg_no are primary key

how do i group camp by its name and also display the no of category in that particular camp.

kindly post the query that you are currently working on.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.