Yes.

If i replace the top n with select * and leave the rest of the script the same I get a lot of records back.

The error exist only if i have more than a few tables in the join and use top n

Take top n out and i can join on as many tables as i want.