Your problem is you aren't understanding the query syntax.
Here's a multi-table query with some whitespace, maybe this will help you understand what the highly unstandardized query you're looking at is doing.
Code:
SELECT
`table1`.`column1` , `table2`.`column1`
FROM
`table1_full_name` AS `table1`
JOIN
`table2_full_name` AS `table2`
ON `table1`.`column2` = `table2`.`column2`