You neglected to add the table alias to all the columns.

Give us this info and maybe we can help

- Chris