Member Avatar for anand9796

How to use pivoting WIth join of 3 tables without Aggregate function within it

  • 2 Contributors
  • 2 Replies
  • 213 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by alan.davies
Member Avatar for alan.davies

Why do you need to avoid aggregate functions? What data are you trying to pivot? No info supplied so it's v difficult to help you.

commented: I just want to display boolean value in pivoted column +0
Member Avatar for alan.davies

May be my display, but I can't see any tags so not sure which rdbms you're using. Each flavour of sql deals with different syntax. Also need an idea of table structure and joins. Nothing much to go 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.