oracle 8.1.6 select product_name, ec_product_comment_id_sequence.nextval as comment_id, user_email, to_char(sysdate,'Day Month DD, YYYY') as current_date from ec_products, (select email as user_email from cc_users where user_id = :user_id) where product_id=:product_id