Code: Select all
+--------------------------+
| Tables_in_thee_libraries |
+--------------------------+
| files |
| quotes |
| quotes_to_file |
+--------------------------+Code: Select all
SELECT
q.`quote_id`, qf.`quote_id`, qf.`file_id`, f.`file_name`
FROM
quotes q, quotes_to_file qf, files f
WHERE
q.`quote_id` = qf.`quote_id`
AND
`quote_visible` = 2;Code: Select all
+----------+----------+---------+----------------------------+
| QUOTE_ID | quote_id | file_id | file_name |
+----------+----------+---------+----------------------------+
| 2 | 2 | 19 | 708435091441845b8a8905.jpg |
+----------+----------+---------+----------------------------+However, I would still like to be able to get the quote from the quotes table even if there are no files associated with it, is this possible?