Join many table with 1 query is the ideal. Because you must sure that
there are the valid data integrity. If there is only 1 broken join key
(any part of table1.key=table2.key), you'll got the null row. When you
need to display all of the first table value and retrieve another
information
Can anyone tell me a more efficient way to structure this query? It
works fast enough now, but I don't have that much data yet. I am
concerned with future performance.
I need all of the rows from the project table that match the first where
clause. The other information saves me from having to
