# Copyright (c) reifydb.com 2026
# This file is licensed under the AGPL-3.0-or-later, see license.md file
# JOINs
transpile 'SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.b'
---
FROM t1 JOIN {FROM t2} AS t2 USING (a, t2.b)
transpile 'SELECT * FROM t1 LEFT JOIN t2 ON t1.a = t2.b'
---
FROM t1 LEFT JOIN {FROM t2} AS t2 USING (a, t2.b)
transpile 'SELECT * FROM t1 JOIN t2 ON t1.a = t2.b'
---
FROM t1 JOIN {FROM t2} AS t2 USING (a, t2.b)