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

Recommended Answers

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.

Jump to Post

All 2 Replies

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

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 learning and sharing knowledge.