Joining name/value data to flat data

T

Tony Cook

Hi,

I have 2 tables, tblAccount and tblAttribute. tblAccount is a 1 row per user
affair, whereas tblAttribute is a name/value table. What I need to do is to
combine all the data into a 1 row per user query. Something like:

SELECT tblAccount .*,
tblAttribute.Value AS EmploymentOccupation WHERE
tblAttribute.Name='EmploymentOccupation',
tblAttribute.Value AS EmploymentStatus WHERE
tblAttribute.Name='EmploymentStatus'
FROM tblAccount
INNER JOIN tblAttribute ON tblAccount.ID = tblAttribute.ID

I know this isn't the way to do this, but any pointers gratefully received.

TIA,
TC
 
Top