HI , Below sample used to get data from same table using 2(A,B)
buffer’s. Ex: Should get data from A which doesn’t have records in B
based on catalog condition.
while select priceDiscTableSource
where priceDiscTableSource.OCSCatalogueRelation == sourceCatalog
notexists join priceDiscTableDestination
where priceDiscTableSource.ItemRelation == priceDiscTableDestination.ItemRelation
&& priceDiscTableDestination.OCSCatalogueRelation == diaCatalogDestination
while select priceDiscTableSource
where priceDiscTableSource.OCSCatalogueRelation == sourceCatalog
notexists join priceDiscTableDestination
where priceDiscTableSource.ItemRelation == priceDiscTableDestination.ItemRelation
&& priceDiscTableDestination.OCSCatalogueRelation == diaCatalogDestination
No comments:
Post a Comment