How do I display data from table2 via table1 using mysql?

Question

I have two tables, directory, and pictures. Both directory and pictures contain an ID number in column 1. I want row 1 (ID 1) of directory to pull information of pictures. I want it to be versatile, i.e. if I pull ID 2 from directory it will show ID 2 from pictures.

I want directory.ID to pull Pictures.photo based on ID. Maybe this makes more sense...

Answer 1

For this purpose you should use a JOIN.

select * 
from directory d
JOIN pictures p ON d.ID = p.ID