postgresql 7.1 select product_name, ec_product_comment_id_sequence.nextval as comment_id, user_email, to_char(current_timestamp,'Day Month DD, YYYY') as current_date from ec_products, (select email as user_email from cc_users where user_id = :user_id) as cc_emails where product_id=:product_id