[solved] Inner Join Active Record

[eluser]a&w[/eluser]
How approaching this a different way? Forget CI. IF you had to build the sql query using a join statement what would the sql query look like? Because I was also just testing the query against mysql and getting the same result. So this is more of an issue with the query itself (at least at this point).