SPList _listrequest = _web.Lists.TryGetList("Employee Details"); SPList _listtask = _web.Lists.TryGetList("Department"); if (_listrequest != null && _listtask != null) { SPField emp = _listrequest.Fields["EmployeeName"]; SPField dept = _listtask.Fields["EmployeeName"]; _query = new SPQuery(); _query.Joins = "<Join Type='INNER' ListAlias='Department'>" + "<Eq>" + "<FieldRef Name='" + emp.InternalName + "' RefType='Id'/>" + "<FieldRef List='Department' Name='ID'/>" + "</Eq>" + "</Join>"; _query.ProjectedFields = "<Field Name='EmployeeNametest' Type='Lookup' List='Department' ShowField='" + dept.InternalName + "'/>"; _query.ViewFields = "<FieldRef Name='EmployeeName' />" + "<FieldRef Name='Department' />";// +
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)