```sqlname(s)

FROM table1

JOIN table2namename;

```sql

SELECT *

FROM table1

JOIN table2namenamename = 'value'name = 'value'name = 'value'

```sql

SELECT *

FROM database1.table1

JOIN database2.table2namenamename = 'value'name = 'value'name = 'value'

```sql

SELECT *

FROM ODBC.data_source.table1

JOIN ODBC.data_source.table2namenamename = 'value'name = 'value'name = 'value'