Query selects distinct records by default

saurabhnarula

14-02-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

15-02-2019

Hi,

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

Thanks,

-Jon

Answers (0)