Consider the following tables/fields:
table "person": fields "p_id", "p_name".
table "person_attribute": fields "a_id", "a_name".
table "person_data": fields "d_person_id", "d_attribute_id",
Also consider that a person may not have data related to all possible
Using this structure, how could I retrieve in one row with a single
select statement all attributes from a person (showing null to
attributes that were not registered to him)?
Thanks for any suggestion,
Sao Paulo - SP - Brasil
pgsql-sql by date
|Next:||From: Stephan Szabo||Date: 2000-08-24 18:45:19|
|Subject: Re: Question on string value expression wildcarding|
|Previous:||From: Steve Wampler||Date: 2000-08-24 18:15:42|
|Subject: Question on string value expression wildcarding|