Got it!!
select CM_NIMBUS_PROBE.probe_name,CM_NIMBUS_ROBOT.robot,CM_NIMBUS_PROBE.probe_group,CM_NIMBUS_PROBE.pkg_version,CM_NIMBUS_PROBE.port
from CM_NIMBUS_PROBE Inner join CM_NIMBUS_ROBOT on CM_NIMBUS_PROBE.robot_id= CM_NIMBUS_ROBOT.robot_id where CM_NIMBUS_PROBE.active=1 and CM_NIMBUS_ROBOT.robot_active=1;