SQL Reference
Is comparing fields across Data Extensions supported in DESelect?
question is comparing fields (sql val1 = val2, val1 > val2 etc ) across data extensions supported in deselect? answer yes, comparing fields across data extensions is supported in filters custom values subqueries (in results/not in results filters) how to compare fields? to compare the value of a field with a field of the same or another data extension, click on the icon to switch to comparing with fields dropdowns appear with the available data extensions and fields you can compare with click on the icon to switch back to filter based on the value you enter when comparing the values of fields, the same operators are available as to when comparing with values entered by the user read more about this functionality here examples you would like to select contacts with a phone number that is equal to the mobile phone number you want to get the order lines where the sales price is higher than the list price