Oracle Implicit vs Explicit Joins and MySQL One-to-Many Aggregation
In Oracle, the queries SELECT * FROM a, b WHERE a.id = b.id and SELECT * FROM a INNER JOIN b ON a.id = b.id are functionally equivalent. Both produce the same result set by matching rows from tables a and b where the id values are equal. However, they differ in syntax style and clarity. The comma-ba...