SQL Query

[Jenny]

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

[Nikolay A Mirin]

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" <je***@nospam.com> wrote in message
news:gy**************@fe10.lga...

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

[Jenny]

thank you for the assist.
jenny

"Jenny" <je***@nospam.com> wrote in message
news:gy**************@fe10.lga...

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