| From: | "Zot O'Connor" <zot(at)zotconsulting(dot)com> |
|---|---|
| To: | postgres sql <pgsql-sql(at)hub(dot)org> |
| Subject: | Finding entries not in table..differnce? |
| Date: | 2000-07-11 00:29:47 |
| Message-ID: | 396A6A7B.39CC7772@zotconsulting.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I need to write a quick function that tells me all of the entriles in
table that are not in table2.
The tables are copies of each other, but 1 has been updated. I know
this is easy, but I am running on little sleep :)
I want to due something like
select prodlang.prodlsku from prodland,prodlang2 WHERE prodlang.prodlsku
!= prodlang2.prodlsku
But of course I would get every record, several times since at some
point the sku does not equal another sku.
I tried !!= (NOT IN) but it did not like that at all, since sku is a
char field.
I am running an older version of postgress on this server, I do not know
if that is important.
--
Zot O'Connor
http://www.ZotConsulting.com
http://www.WhiteKnightHackers.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2000-07-11 00:43:10 | Re: Finding entries not in table..differnce? |
| Previous Message | Abdul Karim | 2000-07-10 22:03:08 | importing in sql |