SQL Join Problem

Posted by Harley on Stack Overflow See other posts from Stack Overflow or by Harley
Published on 2010-03-12T14:43:10Z Indexed on 2010/03/12 14:47 UTC
Read the original article Hit count: 391

Filed under:

Table one contains

ID|Name
1 Mary
2 John

Table two contains

ID|Color
1 Red
1 Blue
2 Green
2 Blue
2 Black

I want to end up with is

ID|Name|Red|Blue|Green|Black
1 Mary    Y      Y
2 John            Y        Y       Y

Thanks for and help.

© Stack Overflow or respective owner

Related posts about sql