>Instead of using INNER JOIN to link-up 2 or more tables, I would like to know that if I use another method for example :-
>
> SELECT a.*, b.Field1 FROM table1 a, table2 b WHERE a.KEY=b.KEY
>
>Will rushmore be applied with this SQL syntax?
As long as the tags are present, it should be. As for me, I have a preference to always have only one table name assigned to the FROM clause. All the rest falls in the INNER JOIN syntax.