Forum Discussion
Postgresql Direct Query Fails on joined tables
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
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.
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.