> where A.FMMPID=11 and B.FMMPID=12 and C.FMMPID=13

I think the stuff in the WHERE clause should be brought up into the FROM ...
JOIN area.

Remember the rule of thumb. DON'T put anything in the WHERE clause that is a
part of the JOIN.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com