Anyways, I’m having a SQL problem right now. I’m developing an application for receiving and sales. Currently I have two tables, one is the "scan" table, which is the items as they are scanned (that's why it's called scan). It has a unique 'id' field that is auto incrementing. Also, there's a serial, partid, PO #, and some other things. The other table is called "sales", which obviously has the sales. This is the one we are most concerned about. In the sales, I have the following columns. Unique auto incrementing id column, iid which is the item id, which refers back to the 'scan' table's id column, the date, serial, partid, returned (bit), datereturned, invoice, customer, and validated. Now what I'm trying to do is to find out which items are still in stock. Now I'm thinking to take the rows from 'sales' that have returned = 0 and some how not include them while SELECTing from 'scan'. I've tried a few different things, however whatever I do, and it doesn't quite work out well. Anybody have any clue what I should do here?