Issue with inner joins

#1

12

I know this was sorted but for some reason, since the new update I am having issues when I put an inner join in on the database.
As soon as I add a join it will not return and query, when I remove the join it works fine.
Is anyone else having this issue or am I doing something wrong?

Using MAC OS

#2

take care about * joker/asterisk queries.
Also as I remember inner/outer/left/right join isnt working on all SQL / Environments Servers (MSSQL/MySQL).

Maybe you forgot to fill a value if not getting back smth from Inner Join. Check first if you really got values linked in both tables

#3

Sorry, don’t follow exactly what you mean, can you explain again?
Not sure if you mean the UI fails or the query fails

#4

Query fails

#5

Have you enabled Debug mode and checked for a 500 error?

#6

4 posts were split to a new topic: Problems with tables join on NodeJS

#7
#8
#9