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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/106881-query/#findComment-547928 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.