Anybody have idea about how to use X++ query for Join and use value of returning from this join.
I mean to say is if we are using query class then we have queryRun.next() to nevigate through data. but same way if we want to use result of join using X++ query then is it possible?
What if you have subselects in the where clause like this
Where (Select asst2.status
from assetbook asst2,
assetbooktable astb2
where astb2.bookid = asst2.bookid
and asst2.assetid = asst.assetid
and astb2.currentoperationstax = 0) <>
(Select asst2.status
from assetbook asst2,
assetbooktable astb2
where astb2.bookid = asst2.bookid
and asst2.assetid = asst.assetid
and astb2.currentoperationstax = 2)
Also what if you have more than one subselect in the select clause like
Select distinct asst.assetid,
(Select asst2.bookid
from assetbook asst2,
assetbooktable astb2
where astb2.bookid = asst2.bookid
and asst2.assetid = asst.assetid
and astb2.currentoperationstax = 0) FinancialBook,
(Select asst2.bookid
from assetbook asst2,
assetbooktable astb2
where astb2.bookid = asst2.bookid
and asst2.assetid = asst.assetid
and astb2.currentoperationstax = 2) TaxBook,
Also, what if you have more than on e subselect in the select clause like:
Select asst.AssetID,
(Select asst2.bookid
from assetbook asst2,
assetbooktable astb2
where astb2.bookid = asst2.bookid
and asst2.assetid = asst.assetid
and astb2.currentoperationstax = 0) FinancialBook,
(Select asst2.bookid
from assetbook asst2,
assetbooktable astb2
where astb2.bookid = asst2.bookid
and asst2.assetid = asst.assetid
and astb2.currentoperationstax = 2) TaxBook,