How can a Cancer Female and Leo Male Be Compatible But Pisces Female is not right for Leo Male?

I just think that the Cancer Female and Pisces Female are so much alike. How can one be right for the Leo male (Cancer female) but the other not be right?