"syntax error" means that what you wrote is not within the syntax that mysql
use, occures very often when you
write something wrong or just have the wrong order in stuff and so on
in this case I think it's because u referes to the alias u and o of the
table before u alias them
it should just be select * from ....
"sam" <rbaba99caramail.com> wrote in message
news:bl91mf$hfq$1news.cybercity.dk...> When I run this SQL query:
> SELECT u.*, o.*
> FROM users u, orders o
> o.client_id = u.user_id;
> I get this error:
> You have an arror in your SQL syntax '' at line 1
> As you see, this error message have nothing to do
> with the stucture of my tables or with what they contain.
> SYNTAX ERROR ???????????????????