Group By...
Hvordan kan jeg gruppere denne sql-sætning efter LevNavn...SELECT t_contractors1.Name AS LevNavn,
t_contractors1.Phone AS LevTel,
t_contractors.Name AS SerNavn,
t_contractors.Phone AS SerTel, t_rma.RMANr,
t_rma.RMAKundeNavn, t_rma.RMAModtDato,
t_articles.ArticleText, t_rma.RMASerienummer,
t_rma.RMAKonfiguration, GETDATE()
- t_rma.RMAModtDato AS [Indleveret antal dage], GETDATE()
- t_rma.RMASendtTilRep AS [Dage til E-rep],
t_rma.RMAExtRMA, t_rma.RMATeknikersFejlbeskr,
t_rma.RMASendtTilRep, t_rma.RMAStatus
FROM t_rma INNER JOIN
t_serials ON
t_rma.RMASerienummer = t_serials.SerialNumber INNER JOIN
t_articles ON
t_serials.ArticleId = t_articles.ArticleId INNER JOIN
t_contractors ON
t_serials.ServiceId = t_contractors.Id INNER JOIN
t_contractors t_contractors1 ON
t_serials.ContractorId = t_contractors1.Id
