List of tickets of the same city

[nanotowers]

Hi Folks,
is possible generate a list or statistic of tickets of the same city of the customers? TY

[crythias]

No, because city is not an attribute of ticket.

A sample can be like this:

Code: Select all

select t.tn as TicketNumber, ts.name as state, customer_user.first_name, customer_user.last_name, customer_user.login, customer_user.city as city from ticket as t left join ticket_state as ts on ts.id=t.ticket_state_id left join customer_user on customer_user.login=t.customer_user_id order by customer_user.city;