Hello,
if I have a table like
with entries
Is there an easy way to script some SQL that would return the following:
i.e. return each name then a list of associated statuses that the name has?
Many thanks...
if I have a table like
Code:
Name varchar(10), Status Varchar(10)with entries
Code:
NameOne StatusOne
NameOne StatusTwo
NameOne StatusThree
NameTwo StatusOne
NameTwo StatusTwoIs there an easy way to script some SQL that would return the following:
Code:
NameOne StatusOne, StatusTwo, StatusThree
NameTwo StatusOne, StatusTwoi.e. return each name then a list of associated statuses that the name has?
Many thanks...