Hello,
I found a strange behavior with my mySQL Server.
I try to do this query:
select t.change_time, t.create_time_unix, t.tn, t.title, t.timeout, q.name AS Queue, ty.name AS 'type', s.name AS Service
from ticket as t
inner join queue as q
on t.queue_id = q.id
inner join ticket_type as ty
on t.type_id = ty.id
inner join service as s
on t.service_id = s.id
I expect a table like:
change_time, create_time_unix, tn, title, timeout, Queue, type, Service
this command works in SQL Studio.
But when I'm using it with the DB Connect App, it gives me back a table like this:
change_time, create_time_unix, tn, title, timeout, name
and name has the data from Service.
Do you guys have an idea what's going wrong and how I can manage this?
Thanks in advance for your help.
... View more