Hi all,
I'm struggling with the following:
I have three different (and quite complex) select-statements that return two columns:
Query 1: select ID, Type1 from ......... (irrelevant)
Query 2: select ID, Type2 from ......... (irrelevant)
Query 3: select ID, Type3 from ......... (irrelevant)
Now, from these three queries, I would like to generate something like this:
| ID | Type1 | Type 2 | Type 3 |
|---|
| 3278562347 | 3 | 3 | 2 |
| 2348723084 | 4 | 2 | 1 |
| 2349283742 | 3 | 3 | 3 |
How do I do this?