rashmi_k28 Posted May 23, 2008 Share Posted May 23, 2008 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. Link to comment https://forums.phpfreaks.com/topic/106881-query/ Share on other sites More sharing options...
Barand Posted May 23, 2008 Share Posted May 23, 2008 SELECT a.* FROM TableA AS a LEFT JOIN TableB AS b ON a.node = b.node AND b.ping_status = 1 Link to comment https://forums.phpfreaks.com/topic/106881-query/#findComment-547928 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.