Sytze, Try
Select date , invnum , prodcode , qty , name >From winhist Inner join winstocks on winhist.prodcode = winstocks.prodcode Where date > repdate On September 16, 2014 10:14:48 PM AST, Sytze de Boer <[email protected]> wrote: >Hello folk >I'm have a problem today (maybe this year even) > >In a simple system where data is stored in standalone DBF files, >I issue a command as follows > >select date,invnum, prodcode, qty from winhist where date>repdate into >table xtable > >I also want the name of the product, which is in a table called >winstocks >(winstocks.name) >Can this be retrieved in a single sql statement ? > > > >-- >Kind regards, >Sytze de Boer >Kiss Software > > >--- StripMime Report -- processed MIME parts --- >multipart/alternative > text/plain (text body -- kept) > text/html >--- > [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/[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.
