Test Case for Triple Join in SQL

SELECT triple_join('A multiple join on the Equipment, EquipmentTypes, and
  RentalInfo works effectively: ',
    CASE WHEN
      (SELECT name, e.riid, rental_start, in_use FROM Equipment AS e JOIN 
        EquipmentTypes ON equipment_type = etid JOIN RentalInfo AS ri ON
        e.riid = ri.riid)
= ('Enabler 420', 1, '20141107', 1)
  THEN 'Passed' ELSE 'Failed' END
  );

This is the code that tests whether my join is working effectively. When I run the code, however, it says I have a syntax error near ",". Can someone tell me what's going on?

P.S.: The Equipment, EquipmentTypes, and RentalInfo are tables I have defined and 'inserted to' in another file.