09. april 2009 - 01:02Der er
3 kommentarer og 1 løsning
SQL Udtræk
Jeg skal trække noget data ud fra Capainstaller Databasen.
Databasen er opbygget således:
ID Section Name Value 626 Operating System Last Boot Time 1239167016 626 Operating System System Microsoft Windows XP 626 Operating System Build 2600 626 Operating System Service Pack Service Pack 3 626 Operating System Type Member Workstation 626 Operating System InstallDate 1220508138 626 Operating System Language English (United States)
SELECT t1.ID, t1.Value, t2.Value FROM ( (SELECT ID, Value FROM Capainstaller WHERE Name = 'System') AS t1 INNER JOIN (SELECT ID, Value FROM Capainstaller WHERE Name = 'Service Pack') AS t2 ON t1.ID = t2.ID)
Mange tak for hjælpen, smider point når jeg finder knappen til det :-)
Skal jeg poste et nyt spørgsmål for at udvide denne??
Jeg skal have en SELECT mere med (InstallDate).
Løsning: SELECT t1.ID, t1.OS, t2.SP FROM (SELECT INV.VALUE AS OS, UNITINV.UNITID AS ID FROM INV INNER JOIN UNITINV ON INV.INVID = UNITINV.INVID WHERE (UNITINV.UNITID = 626) AND (INV.SECTION = 'Operating System') AND (INV.NAME = 'System'))AS t1 INNER JOIN (SELECT INV.VALUE AS SP, UNITINV.UNITID AS ID FROM INV INNER JOIN UNITINV ON INV.INVID = UNITINV.INVID WHERE (UNITINV.UNITID = 626) AND (INV.SECTION = 'Operating System') AND (INV.NAME = 'Service Pack')) AS t2 ON t1.ID = t2.ID
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.