Tracy, this is sweet as......THANK you once again
On Fri, Jul 26, 2013 at 5:23 PM, Tracy Pearson <[email protected]>wrote: > 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 > [excessive quoting removed by server] _______________________________________________ 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/CAG1nNy9U2g6aDivvZe1LdYtC8YNYfOGpgvH+BYti5Gf=zqh...@mail.gmail.com ** 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.
