hi, could someone please tell me how do I get a query to show the (*) fields
in table2 only when table2.field1 exist in table1.field1

thanks in advance.
jenny


table 1 contains
--------------------------
field1
1
5
4
9


table 2 contains
--------------------------------

field1 field2
1 a
1 b
1 j
1 m
2 a
2 b
3 a
3 n
4 c
4 d


--------------
desired results:
---------------

table2.field1 table2.field2
1 a
1 b
1 j
1 m
4 c
4 d

Assuiming the records t2 do not duplicate

SELECT DISTINCT t2.*
FROM table2 t2 LEFT JOIN table1 t1 ON (t1.field1=t2.field1);


Also, check out EXISTS,
http://www.postgresql.org/docs/7.4/i....html#AEN12473


RTFM, RTFM!!!!!


"Jenny" <jenny (AT) nospam (DOT) com> wrote

thank you for the assist.
jenny

"Jenny" <jenny (AT) nospam (DOT) com> wrote