Crackhead

i am having many problems getting my crystal reports to comply with mysql, inner joins require many queries where there should be only three. does any one know a better way