Actually you don't need to specify INNER, the keyword JOIN by itself is implicitly an INNER JOIN. You only need the full syntax when you're using an OUTER JOIN (FULL, LEFT, or RIGHT). Laurie
On 17 September 2014 03:39, Sytze de Boer <[email protected]> wrote: > Frank, perfect > I really need to study this inner and outer stuff > > > On Wed, Sep 17, 2014 at 2:25 PM, Frank Cazabon <[email protected]> > wrote: > > > 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/CAMvTR9es3D5c=j19h_pzpjv7q6vpwfvfmw9_ean9fg3fyhu...@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.
