Hi
select
count(track.id_terminal)
, company.name as myResult
from track,detailsForTerminal, client,service,terminal, customer,customerGroup,Location,Item,company_plan,company
Where track.id_client = client.client_id
and
detailsForTerminal.id_terminal = track.id_terminal
and
detailsForTerminal.id_group = customerGroup.customerGroup_id
and
service.id_client = client.client_id
and
service.id_rm = terminal.terminal_id
and
track.id_customer = customer.customer_id
and
customerGroup.id_customer = customer.customer_id
and terminal.serial = Location.rm_serial
and
Location.id_Item = Item.Item_id
and
Item. id_plan = company_plan.companyplan_id
and company_plan.id_company = company.company_id
and customer.customer_id = 100
group by company.name
How can i go about this kind of query using service builder??
thanks and regards
Priyanka Dhingra
