SELECT something NOT EQUAL to????
От | Sterling |
---|---|
Тема | SELECT something NOT EQUAL to???? |
Дата | |
Msg-id | 3B38399D.F57F8CE0@omeninc.com обсуждение исходный текст |
Список | pgsql-general |
H- I have a sql query that I'm constructing and I need it to select all the records that are not part of these other records. For instance. $project_id = "1"; table "records" project_id int4 employee_id int4 and contains 5 records project_id employee_id 1 2 1 3 2 4 2 2 2 5 table "list" employee_id int4 name varchar(64) and contains 4 records employee_id name 2 John Doe 3 Jane Doe 4 Bill Smith 5 John Denver I have this statement. $sql = "SELECT DISTINCT e.employee_id, e.name, s.project_id FROM list e, records s WHERE s.project_id != '$project_id' ORDER BY last_name ASC"; Now I know that the != isn't part of postgres but I can't figure out what the equivalent operation would be. I've read the postgres guide under WHERE clause but didn't see anything that seemed appropriate, or would work when I plugged it in. > <> >= etc. nothing. It doesn't throw an error when using the != sign though but returns all records of table list. I want it to return all names in list (using employee_id) that aren't already in the records field for a particular project. That would mean the results should only return names that are in project_id 2 which is THREE records for employee_id's 4,2,5 and those record's name. I was earlier able to get the query to pull all records and names associated with a particular project by using a similar string, but that was using e.employee_id=s.employee_id and it pulled all the records fine and only the appropriate records. DB isn't my strong suit and I usually get stuff done through trial and error, examples online and basic knowledge but this sql query is not going well. If any one has any thoughts or suggestions it'd be greatly appreciated. Thanks. -Sterling
В списке pgsql-general по дате отправления: