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
signature.asc
Description: This is a digitally signed message part.
