| From: | Simeó Reig <simeo(at)incofisa(dot)com> |
|---|---|
| To: | "Lista POSTGRESQL" <pgsql-general(at)postgresql(dot)org> |
| Subject: | SQL HELP |
| Date: | 2003-01-17 18:30:34 |
| Message-ID: | 000b01c2be56$86178b30$0500a8c0@incofisa.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've two tables A and B:
Table A
--------
idTableA (Primary key)
otherFields
table B
--------
idTableB
idTableA
otherFields
Primary key (idTableB, idTableA)
I need to known idTableB from table B where have idTableA=1 but not have any
idtable=2
table B
-------
idtableB idTableA OtherFields
1 1 ----
1 2 ----
2 1 -----
3 1 ------
The result must be 2 and 3.
Thanks a lot !!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Kriger | 2003-01-17 18:56:52 | setting a connection timeout? |
| Previous Message | Stephan Szabo | 2003-01-17 18:09:36 | Re: Fix FK deadlock, but no magic please |