Query problem

Tarscher wrote:

I have users (has many) accounts

I want to show all users and the account (if he has one) of a certain
type.

How can I query all users and if the user has a specific account, the
account. If I do :conditions => :accounts.type = 'type' I only get the
users with an account. I also want the users with an account.

Sounds like you want to do the account selection in Rails after the
fact. Something like:

Users.find(:all).each do |user|
  user.show
  account = user.account
  account.show if account && account.type == whaka_whaka
end