Query domain pricing and filter by client group.

[phannh]

Hi all,

I'm trying to write a query to find domain pricing of a client group.

This is my query to list all domain pricing.

 

select tbldomainpricing.extension, tblpricing.*
from tbldomainpricing join tblpricing on tbldomainpricing.id = tblpricing.relid
where type in('domainregister', 'domaintransfer', 'domainrenew');

 

Now how i can filter the result by client group ?

 

Thanks.

[brian!]

tblclientgroups.id = tblpricing.tsetupfee