Sytze de Boer <[email protected]> wrote: >Please help me out > >I have a history file and a stock file >Whats the quickest way to remove any stock items where the stock item >is >not in the history file ?
Backup your data. Tired, about to get into bed, here is something off the tip of my head. Delete from stock where key not in (select key from history group by 1) -- Tracy _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
