n, Montana
-Original Message-
From: Steve Davies [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 12:23 PM
To: [EMAIL PROTECTED]
Subject: Selecting data from one table if it's NOT in another
>
>
>Hi all
>
>There's probably a simple answer to this but
>
>
>Hi all
>
>There's probably a simple answer to this but I can't find it and it's
>doing my head in.
>
>I have two tables:
>main contains user data, address,name,etc.
>activity contains user activity
>
>'user' in main has the same value as 'id' in activity
>
>I want to produce a list of users
