Re: [SQL] Help with SQL

2002-10-16 Thread Eric L. Blevins
11031 Drew| 30 |104 zombiechick | 3 |159 (4 rows) Thanks for your help! Eric L. Blevins - Original Message ----- From: "Oliver Elphick" <[EMAIL PROTECTED]> To: "Eric L. Blevins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: We

[SQL] Help with SQL

2002-10-16 Thread Eric L. Blevins
I'm new to postgres. I've got 2 SQL statements I would like to combine into one.   I think I need to use a sub select or join I am not sure. Any help would be appreciated!   statement 1: SELECT  uid, count(uid)  FROM triangulated WHERE uid != 'anonymus' AND uid!= 'anonymous' AND uid != '' GRO