Forum Discussion

Sharaz's avatar
Sharaz
Frequent Visitor
7 years ago

Data does not show after editing query

With the following:

As you can see we can see that there is data when im editing query but when i close the edit query dialog and i go to the tables, there is no data, its a left outer join between 2 tables, i have tried refreshing, closing reopening etc but nothing works.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks.

Need Help

5 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Sharaz ,

     

    Firstly, I would suggest you use the latest version of Desktop.

    Secondly, please sort the columns to see if there is any data in it. In other words, maybe the empty parts show up at the top. The Left Outer Join could leave blanks on the right.

     

     

    Best Regards,

    • Sharaz's avatar
      Sharaz
      Frequent Visitor
      7 years ago

      Hi v-jiascu-msft, I can't mark that answer as a solution because that wasn't the solution for my problem.

       

      Thank you.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Sharaz,

         

        Have you solved it? If not, can you share the file if possible? Please mask the sensitive parts first. To be honest, we can't troubleshoot such issues based on the description. If yes, could you please share it here?

         

         

        Best Regards,