Member Avatar for suneye

hello,
i have 4 tables in my database persons , nationalities, Persons_nationaloites and certificates
persons_nationalities is the many to many between person and nationality.
certificates and persons are one to many related.

how to write a stored procedure in such a way that i can get the number of nationalites and certificates each person has.
best regards

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by darkelflemurian
Member Avatar for darkelflemurian

can you provide the structure of the tables?

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.