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

Natural Join Is Missing #654

Closed
micah-williamson opened this issue Nov 22, 2021 · 1 comment
Closed

Natural Join Is Missing #654

micah-williamson opened this issue Nov 22, 2021 · 1 comment

Comments

@micah-williamson
Copy link

Hello I am trying to create a NATURAL LEFT JOIN but i don't see an option to.

Of the join types there are:

class JoinType(Enum):
    inner = ""
    left = "LEFT"
    right = "RIGHT"
    outer = "FULL OUTER"
    left_outer = "LEFT OUTER"
    right_outer = "RIGHT OUTER"
    full_outer = "FULL OUTER"
    cross = "CROSS"
    hash = "HASH"

Am I missing a way to create a NATURAL LEFT JOIN or is it not an option?

@micah-williamson micah-williamson changed the title Natural Join Natural Join Is Missing Nov 22, 2021
@micah-williamson
Copy link
Author

Nevermind. I see that this is possible with USING instead of ON

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

1 participant