I have been trying to write a SQL query. The problem I have with this is I want to show the rows as a columns. My database details clients ID number and a serial number as seperate rows, however, I want it show them as a column - is there a way to do this?
The database has the structure shown below as there are several other types of numbers but I am specifically looking at these two types only.
Name Type Number
Joe Bloggs ID Number 123456
Joe Bloggs Serial Number 789101
Jane Bloggs ID Number 543210
Jane Bloggs Serial Number 987654
I want to be
Name ID No Serial Number
Joe Bloggs 123456 789101
Jane Bloggs 543210 987654