Complex SQL Query Entity Attribute

Asked Apr 12 '17 at 16:36

Active Apr 12 '17 at 16:44

Viewed 32 times

I have two tables. And i need a result based on the tables:

Table A: Users

| USER_ID |    NAME| VALUE |
----------------------------
|  1      |     Dan|     P |


Table B: Attachments


| USER_ID |    ATTACHMENT_NAME|
-------------------------------
|  1      |     ATTACHMENT1   |
|  1      |     ATTACHMENT2   |
|  1      |     ATTACHMENT3   |

I need the result to be like this:

| USER_ID |    NAME     |  ATTACHMENT  |  ATTACHMENT | ATTACHMENT |
-------------------------------------------------------------------
|  1      |     DAN     |  ATTACHMENT1 |  ATTACHMENT2| ATTACHMENT3|

The value of attachments is dynamic for every user. But, the number of attachments is always 3. Please help.

Thanks

edited Apr 12 '17 at 16:44

asked Apr 12 '17 at 16:36

Pruthvi Raj Nadimpalli

1,335
1
15
30

Does the number of Attachments change dynamically? – Tom J Muthirenthi Apr 12 '17 at 16:39
@TomJMuthirenthi The number of attachments is always 3 – Pruthvi Raj Nadimpalli Apr 12 '17 at 16:40
That's not complex, this question gets asked almost every day. Use the search function next time. – fancyPants Apr 12 '17 at 16:42
@fancyPants I have tried to search but i can't find one where the value of attachments is dynamic – Pruthvi Raj Nadimpalli Apr 12 '17 at 16:43
First, you say above it's always 3. Second, here you go http://stackoverflow.com/questions/17773045/mysql-dynamic-pivot-table It's not that hard to search...seriously – fancyPants Apr 12 '17 at 17:06

Complex SQL Query Entity Attribute

0 Answers0