Hi,
Le lundi 12 novembre 2007, Reg Me Please a écrit :
> What I'd need to do is to "filter" t1 against f1 to get only the rows
> ( 'field1',1 ) and ( 'field2',1 ).
select * from t1 natural join f1 where t1.id = 1;
t | id
--------+----
field1 | 1
field2 | 1
(2 lignes)
I'm not sure about how you wanted to filter out the ('field1', 2) row of table
t1, so used the where t1.id = 1 restriction.
Hope this helps,
--
dim