I have a table called mytable, and two other tables called option1 and option2
here is their structure:
id, name

id, mytable_id, name

id, mytable_id, name

Some, but not all, entries for mytable will be linked to option1 and option2.

I would like to have one query that selects all the rows from mytable, and if there is an option1 entry for that mytable row, grab it as well, and the same for option2

The only way i know how to do this now is to run a query for all the mytable rows and then in a php while loop, query to see if there are any option1 or option2 entries that are linked to mytable.

The main crux of this thing is that not every mytable entry is linked to an option1 or option2

thanks for any help!