I have a table Table "test" Column | Type | Modifiers --------+------------------------+---------- data | integer | not null data1 | character varying(128) | not null data2 | character varying(128) | not null
(Note: data is NOT the primary key.) And select * from test returns data | data1 | data2 ------+-------+------- 1 | foo | bar 2 | greg | bar 3 | pooh | bar 4 | dah | peng I need a query that returns me the "data1" that satisfies the logic of the following pseudo code: 1: select data2 into @out from test where data1 = 'pooh' 2: select data1 from test where data2 = @out and data = 3 What do I do? Thanks! -- Wei Weng Network Software Engineer KenCast Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly