Hash join: Difference between revisions
Content added Content deleted
m (added whitespace to the task's preamble.) |
|||
Line 1,693: | Line 1,693: | ||
28 | Glory || Glory | Buffy |
28 | Glory || Glory | Buffy |
||
</pre> |
</pre> |
||
=={{header|Run BASIC}}== |
|||
<lang Runbasic>sqliteconnect #mem, ":memory:" |
|||
#mem execute("CREATE TABLE t_age(age,name)") |
|||
#mem execute("CREATE TABLE t_name(name,nemesis)") |
|||
#mem execute("INSERT INTO t_age VALUES(27,'Jonah')") |
|||
#mem execute("INSERT INTO t_age VALUES(18,'Alan')") |
|||
#mem execute("INSERT INTO t_age VALUES(28,'Glory')") |
|||
#mem execute("INSERT INTO t_age VALUES(18,'Popeye')") |
|||
#mem execute("INSERT INTO t_age VALUES(28,'Alan')") |
|||
#mem execute("INSERT INTO t_name VALUES('Jonah','Whales')") |
|||
#mem execute("INSERT INTO t_name VALUES('Jonah','Spiders')") |
|||
#mem execute("INSERT INTO t_name VALUES('Alan','Ghosts')") |
|||
#mem execute("INSERT INTO t_name VALUES('Alan','Zombies')") |
|||
#mem execute("INSERT INTO t_name VALUES('Glory','Buffy')") |
|||
#mem execute("SELECT *,t_age.name FROM t_age LEFT JOIN t_name ON t_name.name = t_age.name") |
|||
WHILE #mem hasanswer() |
|||
#row = #mem #nextrow() |
|||
age = #row age() |
|||
name$ = #row name$() |
|||
nemesis$ = #row nemesis$() |
|||
print age;" ";name$;" ";nemesis$ |
|||
WEND</lang>Output: |
|||
<pre>27 Jonah Spiders |
|||
27 Jonah Whales |
|||
18 Alan Ghosts |
|||
18 Alan Zombies |
|||
28 Glory Buffy |
|||
18 Popeye |
|||
28 Alan Ghosts |
|||
28 Alan Zombies</pre> |
|||
=={{header|Rust}}== |
=={{header|Rust}}== |