Toad World® Forums

How to fetch the remaining records from a table


#1

Hi Experts,

We have records in table XX_LTST_DETAIL. The few columns in this table are item,family,type,reserve, fiscal_year,period,transaction_type,quantity,value,transaction_date,subinventory.

Now, we created new table XX_LTST_RESERVE_DETAIL where it will fetch few records based on few conditions from above XX_LTST_DETAIL. Now, I need to fetch all the remaining records from XX_LTST_DETAIL. Can any one let me know how to do that…?

Here, XX_LTST_DETAIL may contain more than one record for a single item.


#2

Hi,

Got it.

SELECT * FROM XX_LTST_DETAIL

MINUS

SELECT * FROM XX_LTST_RESERVE_DETAIL;

I forgot my basics :slight_smile: