Is there a better way to write this:
SELECT a.oid_fld FROM for_payment a
WHERE a.serial_fld <> 2
AND EXISTS
(SELECT b.char_fld FROM for_payment b
WHERE b.serial_fld = 2
AND b.char_fld = a.char_fld)
Table for_payment
+-------------+------------+-----------+| serial_fld | char_fld | oid_fld |
+-------------+------------+-----------+| 1 | test1 | 456701 | | 2 | test1
| 456702 | | 3 | test1 | 456703 | | 4 | test2 | 456704 | | 5
| test3 | 456705 |
+-------------+------------+-----------+
sample problem:
Assuming that I pick 2 in serial_fld.
How do I get the oid_fld of the rows with char_fld equal
to the char_fld of 2?
I should get these:
+-----------+| oid_fld |
+-----------+| 456701 | | 456702 |
+-----------+
Thanks.