SQL statement i PHP script
Jeg har det her script jeg skal bruge i PHPKan jeg bare skkrive det ind saadan her, eller er der noget med nogle kommaer, koloner er eller noget andet?
<<STATEMENT>>
SELECT i.individ AS [ID], i.firstName AS [First Name], i.lastname AS [Last Name], MAX(e.eventtime) as [Last Read]
FROM individuals AS i
LEFT JOIN cards AS c ON i.individ = c.indivndx AND i.tenantndx = c.tenantndx
JOIN events AS e ON i.individ = e.indivndx AND i.tenantndx = e.tenantndx AND i.accessverndx = e.accessverndx
JOIN eventtypes as et ON e.eventtypendx = et.eventtypeid
WHERE e.eventtypendx IN (14,16) AND (e.floatvalue <> 1.0)
GROUP BY i.individ, i.firstName, i.lastname
ORDER BY i.individ, i.firstName, i.lastname, [Last Read] DESC
<<STATEMENT>>
