I have two tables with fields I want to join.
Table One.
- id
- article
- author
Table Two.
- id_from_table_one
- path_dir
I want to retrieve the path dir from table two and add it to table 1. The id from table one needs to correspond with the id from table two: that way, I will retrieve the correct image for the query.
Im using PDO and I figured I’d use a join statement, but I can’t seem to make it work.
$query = “SELECT id, article, author FROM Table_One FULL OUTER JOIN Table_two ON folder_path”;
Can someone help me with the correct syntax?