I lang tid har samarbejdsbranchen fokuseret på at forbedre enhedsfunktioner – bedre kameraer, klarere lyd og smartere software. Men den virkelige forvandling handler ikke om funktioner.
Select tblRMA.ID, tblRMA.RMAName, tblRMA.CreatedByID as CreatedBy_ID, U1.initials as CreatedBy_Initials, U1.FullName as CreatedBy_Fullname, tblRMA.CreatedByID as CreatedBy_ID, U2.initials as CreatedBy_Initials, U2.FullName as CreatedBy_Fullname, tblRMA.CreatedByID as CreatedBy_ID, U3.initials as CreatedBy_Initials, U3.FullName as CreatedBy_Fullname From tblRMA inner join tblUser as U1 on tblRMA.CreatedByID = U1.id inner join tblUser as U2 on tblRMA.CreatedByID = U2.id inner join tblUser as U3 on tblRMA.CreatedByID = U3.id
Select tblRMA.ID, tblRMA.RMAName, tblRMA.CreatedByID, U1.initials as CreatedBy_Initials, U1.FullName as CreatedBy_Fullname, tblRMA.ChangedByID, U2.initials as ChangedBy_Initials, U2.FullName as ChangedBy_Fullname, tblRMA.ClosedByID, U3.initials as ClosedBy_Initials, U3.FullName as ClodsedBy_Fullname From tblRMA inner join tblUser as U1 on tblRMA.CreatedByID = U1.id inner join tblUser as U2 on tblRMA.ChangedByID = U2.id inner join tblUser as U3 on tblRMA.ClosedByID = U3.id
Select tblRMA.ID, tblRMA.RMAName, tblRMA.CreatedByID, U1.initials as CreatedBy_Initials, U1.FullName as CreatedBy_Fullname, tblRMA.ChangedByID, U2.initials as ChangedBy_Initials, U2.FullName as ChangedBy_Fullname, tblRMA.ClosedByID, U3.initials as ClosedBy_Initials, U3.FullName as ClodsedBy_Fullname From tblRMA left join tblUser as U1 on tblRMA.CreatedByID = U1.id left join tblUser as U2 on tblRMA.ChangedByID = U2.id left join tblUser as U3 on tblRMA.ClosedByID = U3.id
Ja, det skal det da (være LEFT JOIN) når der skal kunne være NULL værdier.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
