Forum Discussion

Shiny_Felicita's avatar
Shiny_Felicita
Copper Contributor
Oct 16, 2023

Reg: Joining two tables without duplicates

Hi,

I'm trying to join two tables with same id and with different value but not getting the proper output. The value should be changed for the id=1 from resolved to closed. Kindly help me out to resolve this issue.

 

Table 1: tickets

 

Table 2: tickets_new

 

Sql join command used:

select distinct tickets.tid,tickets.status,tickets.priority,tickets_new.tid,tickets_new.status,tickets_new.priority
from tickets
left join tickets_new on tickets.tid=tickets_new.tid;

 

Thanks,

Shiny

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Oct 17, 2023
    Shiny_Felicita wrote: Joining two tables without duplicates

    What for duplicates, I don't see any in your sample data. At all ist your post a bit unclear.

    Please post table design as DDL, some sample data as DML statement and the expected result.

Resources