How to use pivoting WIth join of 3 tables without Aggregate function within it
anand9796
-3
Light Poster
Banned
Recommended Answers
Jump to PostWhy 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.
All 2 Replies
alan.davies
185
What's this?
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.
anand9796
commented:
I just want to display boolean value in pivoted column
+0
alan.davies
185
What's this?
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.