Use X++ query insted of Query Object for join.

[kranthi]

It is as same as writing a select/while select statement and returning the values[:)]