I have a users table that has these columns
[id/twitter_id/name/twitter_name/twitter_image]

and a tweets table that has these
[id/twitter_id/text/date]

and I'm trying to do a custom join by using
Code Ruby:
@tweets = Tweet.find(:all, :joins => 'LEFT JOIN users ON users.twitter_id = tweets.twitter_id' )

however doing an @tweets.inspect shows that only columns in the tweets table are being returned? (so there are not columns from the users table in the result set)

Does anyone know why this is?

I originally tried
Code Ruby:
@tweets = Tweet.find_by_sql('SELECT * FROM tweets, users where tweets.twitter_id = users.twitter_id;' )

but that was doing the same thing.
I'm a bit confused, because I was certain the column/attributes from the users table should have been returned as attributes?