Hi<BR><BR>I need some help about selecting some data from a few tables. I've got an inventory table and i've got a sales table. In the sales table there are only 4 columns, sales_id, inv_id, quant, and date. In the inventory table there are some general fields but the two that are important are inv_id, and quant. When the user enters a sale, it updates the quantity in the inventory table and enters the quantity and inv_id into the sales table. I want to pull a report of all the inventory left in stock that hasn't been sold. Could anyone guide me in the direction of this SQL query?<BR><BR>Thank you SO MUCH!