I have three different tables I am trying to pull info from. Related in different ways. I am trying to find a Join statement that will allow me to pull the information a little better than using the two queries I am now.
Here is what I have
SELECT * FROM reports LEFT JOIN students USING (sID)
You can do the following
SELECT * FROM reports LEFT JOIN students USING (sID) LEFT JOIN table3 USING (pID)
table3 is the name of your table.