pandemonium7386
New member
Let's say, I have a table called "Cars" and it looks like this
Brand - Color
Honda - White
Honda - White
Honda - Blue
What would the mysql code be to make the table look like this (preferably a join command?)
Honda - White - NULL
Honda - NULL - Blue
(Basically, there are two color columns and the first column will show White or NULL and the second color column will show Blue or NULL)
Brand - Color
Honda - White
Honda - White
Honda - Blue
What would the mysql code be to make the table look like this (preferably a join command?)
Honda - White - NULL
Honda - NULL - Blue
(Basically, there are two color columns and the first column will show White or NULL and the second color column will show Blue or NULL)