Ahoj, mám dotaz:

    select cast(lsd.OrdNumber as integer), fi.Name,   
      ib_decodedate_day(lsd.Docdate$date) || '.' || ib_decodedate_month(lsd.Docdate$date) || '.' || ib_decodedate_year(lsd.Docdate$date),
         lsd.id, addresses.city ||' '|| addresses.Street ||' ' || addresses.PostCode
            from LogStoreDocuments lsd
               join Firms fi on  lsd.Firm_ID = fi.ID  
     join STOREDOCUMENTS on lsd.STOREDOCUMENT_ID = STOREDOCUMENTS.ID  
     join FIRMOFFICES on FIRMOFFICES.ID = STOREDOCUMENTS.FIRMOFFICE_ID  
     join addresses on FirmOffices.ADDRESS_ID = addresses.id 
     join logstoredocuments2 on logstoredocuments2.parent_id = lsd.id 
      where lsd.Firm_ID = fi.ID and    lsd.x_zpracoval_terminal <> 'A' and lsd.documentType = 32 and 
 (lsd.x_uzamkl = '') and logstoredocuments2.store_id = '5100000101' order by lsd.OrdNumber

Dotaz funguje ok, ale vrací duplicitní řádky.
Já chci, aby vracel jen řádky s odlišnými lsd.id.


Nemohu to jednoduše pořešit vložením group by lsd.id, protože to nefunguje takto s join.

Nějaká rada?