Hi there,
I have a table which contains two or more row per item.
So per item i will have 3 data for example(as column key will have price, description,extra info). the reason i did it like that is that later on i can come and customize an item and add an extra details or two ie. name, type etc…
Is there a way to group all of them under one data when using the SELECT?
The only i can do this is to use subqueries SELECT within a case statement, but would it not be slow when there will be thousands and thousands of rows?
Please if anybody can help me, it will be great.
Thanks a lot,
regards
jerome