Someone earlier asked a good question - does Oracle support the newer syntax?  (I might have to extract data from an Oracle system soon - would hate to have to write in different syntax for something as simple as joins!).  Also, how did Oracle get the correct results from the possibly ambiguous query - does it make a better guess about join conditions vs filtering conditions?