postgresql7.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