sql - ANSI JOIN ORACLE with 2 common tables -
i want on oracle ansi join:
select * ticket, --here have more tables relates ticket ticket_evo, user usr_client, user usr_support ticket.id = ticket_evo.id --ticket_evo child of ticket , ticket.cd_user = usr_client.cd_user --ticket has client user opened ticket , ticket_evo.cd_user = usr_support.cd_user --ticket_evo has support user answer client on each evolution
thank you!
select * ticket join ticket_evo on ticket.id = ticket_evo.id join user usr_client on ticket.cd_user = usr_client.cd_user join user usr_support on ticket_evo.cd_user = usr_support.cd_user
Comments
Post a Comment