OK, so the origianl SQL without the where clause is:
SELECT toys.*, MIT_Link
FROM toys
LEFT OUTER JOIN MIT ON MIT.MIT_ID = toys.MIT_ID
edit that to:
SELECT toys.*, MIT_Link, dcAdaptor.*, footpad.*
FROM toys
LEFT OUTER JOIN MIT ON MIT.MIT_ID = toys.MIT_ID
LEFT OUTER JOIN dcAdaptor ON dcAdaptor.dcAdaptor_ID = toys.dcAdaptor_ID
LEFT OUTER JOIN footpad ON footpad.footpad_ID = toys.footpad_ID
leave the where clause untouched.