sql - Count the number of rows of an aliased table -

sql - Count the number of rows of an aliased table -

select count (*) (select a.account_poid_id0,a.status moov_profile_status,b.sub_plan_id,b.plan_id,c.status,c.name vms_moov_profile_t a, vms_sub_plan_no_regen_t b, vms_voucher_conf_t c, b.account_poid_id0 = a.account_poid_id0 , c.voucher_id = (select f.voucher_id vms_plan_voucher_t f f.plan_id = b.plan_id));

this returns error. how can count number of rows?

try select count (*) (select a.account_poid_id0, a.status moov_profile_status, b.sub_plan_id, b.plan_id, c.status, c.name vms_moov_profile_t a, vms_sub_plan_no_regen_t b, vms_voucher_conf_t c b.account_poid_id0 = a.account_poid_id0 , c.voucher_id = (select f.voucher_id vms_plan_voucher_t f f.plan_id = b.plan_id)) t

sql