Jean MAURICE wrote:
That's true but when you read your query some years later, it's easier
to remember what it does when 'inner' is written !!
Another point : it's better to use local aliases in your query at
least for the human being reading it :
Select h.date, h.invnum, h.prodcode, h.qty, s.name ;
From winhist h Inner join winstocks s on h.prodcode = s.prodcode
Where h.date > repdate
For inner joins I just use the "old" syntax, which I think is simpler
and only use alias where needed (like below for duplicate field names)
Select date, invnum, winhist.prodcode, qty, name ;
From winhist, winstocks ;
Where winhist.prodcode = winstock.prodcode and date > repdate
Peter
_______________________________________________
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.
