Query selects distinct records by default

[#1]

When I select data using Query from Workflow Targeting activities, then the query by default selects distinct records. What is the best way to select all records and not just distinct.

Thanks

Saurabh

[#2 · Accepted solution]

Hi,

Click 'Advanced parameters...' in the 'Additional columns' dialog, there's a checkbox to turn off DISTINCT in the select.

Thanks,

-Jon