On Tue, 26 Jun 2001 07:27:10 GMT, Sterling <smullett@omeninc.com> wrote:
> 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";
>
A few problems:
not sure you need to SELECT DISTINCT on this query
s.project_id is int4, so no 'quotes' around the value
what is last_name? it is not in these table definitions
SELECT
e.employee_id,
e.name,
s.project_id
FROM
list e
NATURAL JOIN
records s
WHERE
s.project_id != 1
ORDER BY
name