Re: [SQL] Selecting records not present in related tables

2005-10-06 Thread Anthony Molinaro
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hector Rosas Sent: Thursday, October 06, 2005 3:44 PM To: pgsql-sql@postgresql.org Subject: [SQL] Selecting records not present in related tables   Hello, I'm trying to select records in a table not present in a related table, in example,

Re: [SQL] Selecting records not present in related tables

2005-10-06 Thread Scott Marlowe
On Thu, 2005-10-06 at 14:43, Hector Rosas wrote: > Hello, I'm trying to select records in a table not present in a > related table, in example, I've a table with message information > (subject, message, date, etc) and another (usermessages) with where > user(s) has that message, its state, etc. Rec

Re: [SQL] Selecting records not present in related tables

2005-10-06 Thread Frank Bax
At 03:43 PM 10/6/05, Hector Rosas wrote: Hello, I'm trying to select records in a table not present in a related table, in example, I've a table with message information (subject, message, date, etc) and another (usermessages) with where user(s) has that message, its state, etc. Records in thi

[SQL] Selecting records not present in related tables

2005-10-06 Thread Hector Rosas
Hello, I'm trying to select records in a table not present in a related table, in example, I've a table with message information (subject, message, date, etc) and another (usermessages) with where user(s) has that message, its state, etc. Records in this table will be deleted in a certain time (jus