select taska.taskaszam, taska.rendszam, cast(szallit.raklapjel as Varchar(50)) as raklapjel,
szallit.*,
SUBSTRING(partner.company from 1 for 10)+ ' ][ ' + taska.cim as cim, taska.userkod, taska.terv,
taska.problema, taska.lezartdiszpo, partner.engedely, taska.partner, auto.nev as autonev, user.nev as usernev,
taska.szallproblema, taska.szallmemo
from szallit
inner join taska on taska.szam=szallit.taskaszam
inner join user on taska.userkod=user.kod
inner join partner on taska.partner=partner.code
left join auto on auto.kod=szallit.autokod
where 
not (szallit.ok)
and
not (szallit.sajat)
and 
(szallit.pld>0)
order by szallit.datum, szallit.ido