Forum Discussion

amitchandak's avatar
amitchandak
Super User
7 years ago

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

Need Help

5 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    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's avatar
      amitchandak
      Super User
      7 years ago

      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.

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      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.