Re: help with a simple SQL query
От | Derrick Betts |
---|---|
Тема | Re: help with a simple SQL query |
Дата | |
Msg-id | 09bb01c59071$291bf750$0202a8c0@main обсуждение исходный текст |
Ответ на | help with a simple SQL query ("Andrew Stuart" <andrew.stuart@flatraterecruitment.com.au>) |
Список | pgsql-novice |
SELECT emails FROM table2 WHERE sender_address NOT IN (SELECT sender_address FROM table1); That should work. Derrick ----- Original Message ----- From: "Andrew Stuart" <andrew.stuart@flatraterecruitment.com.au> To: <pgsql-novice@postgresql.org> Sent: Wednesday, July 20, 2005 4:11 AM Subject: [NOVICE] help with a simple SQL query > Hello > > I'm a newb. I'd love some help solving this apparently simple query. > > table one contains email sender addresses > table two contains emails > >From table two I wish to SELECT all emails whose sender address is not in > table one. > > Can anyone suggest how this might be done? > > Thanks in advance > > Andrew Stuart > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > >
В списке pgsql-novice по дате отправления: