General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hello!
SELECT * FROM Table1 WHERE PrimaryKey NOT IN (SELECT ForeignKey FROM Table2)
Alexander
>Table1 is related to Table2.
>I want to run a SELECT on Table1 and only obtain records that DO NOT have a
>related record in Table2.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only