I have two tables, table a and table b.
I do :
[CODE=mysql]select *
from a
inner join b
on b.some = a.something
where b.another = somevalue[/CODE]
How can I put another WHERE to sort my data but for an attribute from table a.
When I put it after the last WHERE it doesn't bring me any results.
Thanks
I do :
[CODE=mysql]select *
from a
inner join b
on b.some = a.something
where b.another = somevalue[/CODE]
How can I put another WHERE to sort my data but for an attribute from table a.
When I put it after the last WHERE it doesn't bring me any results.
Thanks
Comment