search

kristijanhusak / vim-dadbod-ui

Simple UI for https://github.com/tpope/vim-dadbod
MIT License
1.54k stars 94 forks source link

JOIN not working with SQL Server #236

Closed Maduki-tech closed 6 months ago

Maduki-tech commented 6 months ago

Hello, I'm trying out this Plugin, I can not make the JOIN work with an SQL Server connection (Don't know if it working with another connection)

Information I'm new to SQL in general

So I try to learn SQL now and I expect that this code is working:

Screenshot 2024-05-18 at 21 17 15

In my understanding, I expect that the table also shows the posts.

When I run the same query on the same DB via Table Plus ( MacOS DB Tool ) I get the correct response Screenshot 2024-05-18 at 21 18 48

I use Nvim 0.10, No modification to the Plugin or to vim-dadbod.

dbmatheus commented 6 months ago

Hi @Maduki-tech, I think that you're not scrolling to the right to see the other columns. It's just formatting. I'm not sure in SQL Server but prior to the query you usually format the output limiting the number of characters.

Maduki-tech commented 6 months ago

Oh yes you are right! Thx @dbmatheus