I created a webpart form that submits data to two different custom tables, when the data is submitted i would like to create an event receiver that gets value from both tables, then update my CRM.
I have problem getting the value after joining the two tables.
var tables = CustomTableItemProvider.GetItems(e.Item.CustomTableClassName)
.Source(items => items.LeftJoin(CustomTableItemProvider.GetItems("ProductTypeItem").QueryText))