Re: [GENERAL] Select / sub select? query... help...

2006-05-01 Thread Jim Fitzgerald
Thanks for the advice.. I got it working! -Jim "Jim Fitzgerald" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello - > > I'm trying to figure out how to write a particular query and need some > assistance. I imagine this is extremely

[GENERAL] How would I write this query...

2006-05-01 Thread Jim Fitzgerald
Hi - I have two tables, one of them has names of people and an associated integer ID. The other table is a list of the people (from the first table) by their ID number that have signed up for a class. How would I write a query that would list all the people from the first table that do not

[GENERAL] Select / sub select? query... help...

2006-04-29 Thread Jim Fitzgerald
Hello - I'm trying to figure out how to write a particular query and need some assistance. I imagine this is extremely simple. I have the table defined below with five records. This table keeps track of peoples names. Each person has a unique ID number ("person_id"). The table can also k