Hello SELECT i.name, p.property_name, p.property_value FROM sample_info i JOIN sample_properties p ON i.id = p.id
maybe Pavel 2008/6/10 maria s <[EMAIL PROTECTED]>: > Hello friends, > I need help in write a query. > > I have 2 tables, one is sample_info and sample_properties, > > sample_info (id integer, string name) > ------------------ > 1, c_01 > 2, c_02 > ... > > sample_properties(sample_id integer(ref. sample_info), property_name string > ,property_value string ) > ------------------------- > 1, prop1, value1 > 1, prop2, value2 > 2, prop1, value1 > 2, prop2, value 2 > 2, prop3, value3 > > > I would like to get the result by joining 2 tables, for sample id 1 from > sample_info, the result should be > > 1,c_01,value1,value2 > > for sample 2 > > 2, c_02,value1,value2,value3 > > with property_value column header as property_name > > Can anyone help me to write a query /function/view to get the above output? > > Thank you so much for your help. > > -maria > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql