postgresql7.4 SELECT s.title || ' ' || u.first_names || ' ' || u.last_name AS pretty_name FROM cc_staff s, cc_users u WHERE s.staff_id = u.user_id AND s.staff_id = :staff_id SELECT * FROM cc_stream WHERE coordinator_id = :user_id LIMIT 1 SELECT * FROM cc_staff WHERE staff_id = :user_id LIMIT 1