This can be acheived by decreasing the logical size of the

desire table in a such a way that it should be less than

other tables. AS Microstrategy will look the tale having

the least logical size and will make a join with that table.