# Copyright (c) reifydb.com 2025
# This file is licensed under the Apache-2.0, 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)