querybuilder icon indicating copy to clipboard operation
querybuilder copied to clipboard
verified publisher icon sqlkata

Distinct AsCount error

Open Wimmen opened this issue 2 years ago • 0 comments

I have a query with joins and a select distinct for some columns. The query gives normal results, but when I want to get a count of the query with await query.AsCount().GetAsync(); I get the error: The column 'Id' was specified multiple times for 'countQuery'

Any suggestions how to solve this?

Wimmen avatar Jan 25 '24 12:01 Wimmen