I am getting sql query problem in CI

[eluser]xwero[/eluser]
this works

Code:

select T.id as idone, W.id as idtwo from table_one T, table_two W where T.id = W.table_one_id

If i use your syntax i get an error in phpmyadmin