We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
(Model1.^all X Model2.^all).grep: { .[0].col1 == .[1].col2 }
should it do something like this?
SELECT table1.*, table2.* FROM table1 as t1 JOIN table2 as t2 ON t1.col1 = t2.col2
The text was updated successfully, but these errors were encountered:
maybe it could be the solution for #345
Sorry, something went wrong.
Looks like a good solution for inner joins, but tricky to extend to outer joins.
my ($left, $right) = [1, 2, 3], [1, 2, 4]; $left.map: -> $lv { |( $lv X ($right.grep( -> $rv {$lv == $rv}) || (Nil)) ) }
--> ((1 1) (2 2) (3 Nil))
((1 1) (2 2) (3 Nil))
For some DBOs this might be better off as a CROSS JOIN.
https://www.w3resource.com/sql/joins/cross-join.php
So that:
(Model1.^all X Model2.^all)
results in:
SELECT * FROM Model1 CROSS JOIN Model2
That is the best match for the X metaop, BTW.
No branches or pull requests
should it do something like this?
The text was updated successfully, but these errors were encountered: