Bass-Invader
TRIBE Member
i probably shouldnt bother bringing this here..but im registered and i need an answer ...stat..
i have a table
userID | item1 | item2 | item3 | item4
how would i perform a query on it such that all the items are in 1 column(userIDs with multiple items would just appear twice..
eg:
steve | gold | silver
rob | axes | chicken
would query to
steve | gold
steve | silver
rob | axes
rob | chicken
is this even possible?
or is there a better way to make a table to represent an ID having 1 to many items in a table?
i have a table
userID | item1 | item2 | item3 | item4
how would i perform a query on it such that all the items are in 1 column(userIDs with multiple items would just appear twice..
eg:
steve | gold | silver
rob | axes | chicken
would query to
steve | gold
steve | silver
rob | axes
rob | chicken
is this even possible?
or is there a better way to make a table to represent an ID having 1 to many items in a table?