Advertisement
Guest User

Untitled

a guest
Feb 27th, 2015
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. <Join Type='LEFT' ListAlias='customer'>
  2. <Eq>
  3. <FieldRef Name='CustomerName' RefType='Id'/>
  4. <FieldRef List='customer' Name='ID'/>
  5. </Eq>
  6. </Join>
  7.  
  8. var query = SPHelper.query().from("Orders)
  9. .join({on: "CustomerName", as: "customer"})
  10. .select(["OrderId", "customer.Address as CustomerAddress"]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement