Hi,

Can anyone put some light on the way the list of tables that should be stated after the FROM clause in a SQL Query.
Since, performance of a query always differs if proper flow of tables are not listed in the FROM clause.

Eg.:

Case 1:
select a.* from a, b where a.id = b.id;

Case 2:
select a.* from b, a where a.id = b.id;

In both the above cases the performance of the query would be different, since after the FROM clause the way the tables are referred are different in both the queries.

Please help in letting me know the CONVENTION of listing tables after the FROM clause.