The title is basically self-explanitory: is there any faster method than LEFT JOIN that will give me the same results or allow me to derive at the same results?