Query

[sandy1028]

Hi,

The fileds of table is
Table A
node

cpu_util

cpu_speed
timestamp

Table B

node

timestamp

ping_status

How to select data from table A if ping_status is 1 in Table B.

[NogDog]

SELECT a.* FROM table_a AS a 
INNER JOIN table_b AS b ON a.node = b.node
WHERE b.ping_status = 1