Hi All,
i have a query related to using join in expression
as you can see their is a logic mentioned in below code which is i am using in a database view but now i need to use this logic in expression rule to fetch the data so any one can help me to implement this logic or you can give any example
we requird the filter on below case
SELECT a.IDeChangeAffectedElements as IDsiteHistory, a.eChangeRequestDetailsID, a.siteid, a.sitename, a.location, a.network, a.elmid, a.elmalias, a.elmaddress, a.createdby, a.createddate, a.modifiedby, a.modifieddate , b.plannedstartdate as startdate, b.plannedenddate as enddate, b.EtimeCode FROM eChangeAffectedElements a WITH(NOLOCK) left join eChangeRequestDetails b WITH(NOLOCK) on a.eChangeRequestDetailsID = b.IDeChangeRequestNumber
Discussion posts and replies are publicly visible