Hello All,
I have two table the look like this (greatly simplified):
ResourceTable
-
int ResourceID
var ResourceName
ResourceLinkTable
-
int ResourceLinkID
int ResourceID
var Text
I need to find all rows in ResourceTable for which there is NO entry in
-Original Message-
From: Dan Lamb [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 9:39 AM
To: [EMAIL PROTECTED]
Subject: select query syntax help
Hello All,
I have two table the look like this (greatly simplified):
ResourceTable
-
int ResourceID
var ResourceName
Dan,
SELECT ResourceTable.* FROM ResourceTable
LEFT JOIN ResourceLinkTable
ON ResourceTable.ResourceID = ResourceLinkTable.ResourceID
WHERE ResourceLinkTable.ResourceID IS NULL;
Regards,
Thomas
On Thu, 30 Oct 2003, Dan Lamb wrote:
Hello All,
I have two table the look like this