We have two lists (Employee and Department), a common column is created in both lists, and now I want to show the name of department while retrieving records from employee list using CAML query. as much as I know Joins can be used in CAML, but its not working. Can someone help with this, this is rather urgent. Thanks