Reakce na odpověď

    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
              left join Firms fi on  lsd.Firm_ID = fi.ID  
     left join STOREDOCUMENTS on lsd.STOREDOCUMENT_ID = STOREDOCUMENTS.ID  
     left join FIRMOFFICES on FIRMOFFICES.ID = STOREDOCUMENTS.FIRMOFFICE_ID  
     left join addresses on FirmOffices.ADDRESS_ID = addresses.id 
     join (select parent_id from logstoredocuments2 where logstoredocuments2.store_id = '5100000101' group by parent_id) 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 = '') order by lsd.OrdNumber
SQL Firebird pomoc s dotazem
