Question on JOIN to query all items NOT in "INNER JOIN" ?
Posted on 2007-04-06
I need to work on a query to get records that are not found in another table. For example, table CompleteList saves all the list items. Table UsedItems saves items being used. I need to create a query to get all the available items: CompleteList minus UsedItems. I think I could use subquery to do it, but it low efficient. How do we use join to achieve this?