Postgresql Direct Query Fails on joined tables

[amitchandak]

I connected to Postgresql using direct Query. But when I try to get data it errors out. Using the latest version of NPGSQL 4.0.9

[v-xuding-msft]

Hi @amitchandak ,

In my sample, it worked fine. I think the scenario may be caused when you merge queries.  Can you please share some screenshots about the step of merging queries and the results? You could mask the sensitive data.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

I added tables and joined them. And they trying to get data. Till the time I get data from one table, it is working. But if I use two tables, it is not working.

[amitchandak]

@ImkeF, Please suggest.

[amitchandak]

Anyway to resolve this

[amitchandak]

I have taken two tables in Direct query mode.

Joined them on Key column.

And then try to run a query where view by/group by is from the first table and agg column from the second tables.