I am thinking that I really need to start doing it
If I have two tables and wish to tie them together I would use a join correct? Currently I do the following:
SELECT * FROM table1, table2 WHERE table1.id = 3 AND table1.id = table2.id
Would I be able to use a JOIN with that? I guess what I am really trying to do is select values from 3 seperate tables that all have some sort of correleation between them. IE an id field
Am I understanding how JOINs work? It mushes multple tables together into sort of a 'pseudo' table?