Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Incorrect with join where and select where #2

Open
korazy8s opened this issue Apr 19, 2021 · 1 comment
Open

Incorrect with join where and select where #2

korazy8s opened this issue Apr 19, 2021 · 1 comment

Comments

@korazy8s
Copy link

Using example:

select
one.id,
two.id as twoid,
two.name as twoname
from one
left join two on two.parentid = one.id and one.status=1
where one.date >= '2021-01-01'

On the left join with a condition to a value, should be a 'where' not 'on'.
On the where clause, '>=' doesn't get recognized properly.

@jjlabajo
Copy link
Owner

Thanks @korazy8s , pushed a fix. You may close this issue once confirmed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants