here's my problem i need to make a site in wich services are registered and checked for updates.
for this purpose i made 2 tables 1 table has the names of the srvices that need to be updated and the
other is updated autmaticly. i need a query wich checks the first table for the services that need to be checked
and then get the latest update from the second table.
example:
table 1
has 3 services
table 2 has 5 services with about 100 records.
i need to display only the last update from the 3 services mentioned in the first table.
full code i have:
Code: Select all
SELECT dbo.ryuuka_services_status.servernaam, dbo.ryuuka_services_status.servicenaam, dbo.ryuuka_services_status.status,
MAX(dbo.ryuuka_services_status.lastcheck) AS dbo.ryuuka_services_status.lastcheck
FROM dbo.ryuuka_services_status INNER JOIN
(SELECT TOP 9999 dbo.ryuuka_services_status.servernaam, MAX(dbo.ryuuka_services_status.lastcheck),
AS dbo.ryuuka_services_status.lastcheck, dbo.ryuuka_services_status.status, dbo.ryuuka_services_status.servicenaam
FROM ryuuka_log_Services A
WHERE (dbo.ryuuka_services_status.lastcheck =
(SELECT TOP 1 dbo.ryuuka_services_status.lastcheck, dbo.ryuuka_services_status.servicenaam
FROM ryuuka_services_status
WHERE (dbo.ryuuka_log_Services.controleren = '1') AND
(dbo.ryuuka_log_Services.servicenaam LIKE dbo.ryuuka_services_status.servicenaam))
GROUP BY dbo.ryuuka_services_status.servernaam, dbo.ryuuka_services_status.servicenaam, dbo.gispen_services_status.status
ORDER BY dbo.ryuuka_services_status.servernaam, dbo.ryuuka_services_status.lastcheck DESC) DERIVEDTBL
GROUP BY dbo.ryuuka_services_status.servernaam, dbo.ryuuka_services_status.lastcheck, dbo.ryuuka_services_status.status,
dbo.ryuuka_services_status.servicenaamthat was the full code i got i have a simpler one 2 but that one only displays the last update that was made and not the needed updates.
Code: Select all
SELECT ryuuka_services_status.servernaam, ryuuka_services_status.servicenaam, ryuuka_services_status.status, ryuuka_services_status.lastcheck
FROM ryuuka_services_status INNER JOIN
ryuuka_log_Services ON ryuuka_services_status.servicenaam = ryuuka_log_Services.servicenaam
WHERE (ryuuka_log_Services.controleren = '1') AND (ryuuka_log_Services.servicenaam LIKE ryuuka_services_status.servicenaam)