i have 2 tables
table1 with columns number,category,answer
table2 wtih columns number, category, answer
table 1 looks something like this:
number category answer
1 training yes
3 coaching no
table 2 like this:
Number category answer
2 walking yes
I want to make a new table that consists out of the category answer only and should look something like this
Column heaaders should be training, coaching, walking
example,
coaching training walking
yes no yes
Can someone help me with a Query or an idea?
Bookmarks