SELECT     t.idTicket, k2.text AS statustext, t.erstellDatum, t.ablaufDatum, t.gueltig, t.einmalig, g.nname, t.ausfuehrender, t.empfaenger, k.text AS rubriktext,
                     p.posNr, p.anzahl, p.gegenstand, p.hersteller, p.seriennummer
FROM         dbo.Ticket AS t INNER JOIN
                     dbo.Kuerzel AS k ON k.zeichen = t.rubrik INNER JOIN
                     dbo.Kuerzel AS k2 ON k2.zeichen = l.status INNER JOIN
                     dbo.TicketLog AS l ON t.lastFkTicketLog = l.idTicketLog AND k2.zeichen = l.status INNER JOIN
                     dbo.TicketPos AS p ON t.idTicket = p.fkTicket INNER JOIN
                     dbo.Genehmiger AS g ON t.fkGenehmiger = g.idGenehmiger
WHERE     (k.klasse = 'ticket.rubrik') AND (k2.klasse = 'ticketLog.status')