SELECT sd.site_id, sd.site_name, sd.site_address,
SUM(eb_time) as eb_time,
avg(av.dc_volt) as dc_volt
FROM site_details sd
INNER JOIN alarm_time at ON at.site_id = sd.site_id
INNER JOIN avg_values av ON av.site_id = sd.site_id
GROUP BY sd.site_id, sd.site_name, sd.site_address;
For this the output is
S001 10406 36.085000
S002 3376 29.010000
S003 42 29.000000
SELECT sd.site_id
SUM(eb_time) as eb_time
avg(av.dc_volt) as dc_volt //If i remove this and
FROM site_details sd
INNER JOIN alarm_time at ON at.site_id = sd.site_id
INNER JOIN avg_values av ON av.site_id = sd.site_id// this the output is asshown below
GROUP BY sd.site_id, sd.site_name, sd.site_address;
S001 10406
S002 3376
S003 42
...
Go to the complete details ...