is it wrong if we use this sql statement ..

nawar youssef · October 21st, 2011, 01:12 AM

is it wrong if we use this sql statement

Code:

SELECT gender, sum(numVisits) AS TotalPagesView FROM members m, accessLog al WHERE m.id =al.memberId GROUP BY m.gender;

instead of what the book tells us to write :

Code:

SELECT m.gender, sum(al.numVisits) AS TotalPagesView FROM members m, accessLog al WHERE m.id =al.memberId GROUP BY m.gender;

and why if anybody know the answer thank you

UseLess · October 21st, 2011, 02:56 AM

Greetings,

Simply yes.

The book syntax is the correct way to do it as your using an alias m for the members table and as such referencing the gender field from the members table by using m.gender.

The way you have written it;

- which table is the gender field in?
- which table is the numVisits field in?

So now you want SQL to be a mind reader.... ;)