Jump to content

select rows that appear in one table but not another


Recommended Posts

I need to select all the rows from one table (Inventory) that do not appear in my second table (Hire). I need to show which items have never been hired all the items are stored in the inventory table and then the ones that have been hired are recorded in the the hire table.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...