[monkeycantype]

I wish I could use ON for the selection criteria for the first table instead of a where clause:

Select A.value, B.valuue

from tableA A on A.id = 77

join tableB B on B.id = A.bId