sql statement

[eluser]mikeyhell[/eluser]
I'm rescripting and application and ran into an sql statement that's stumped me. Can someone help me understand what's going on here:

Code:

SELECT hotlead_flag, ve.*
FROM vendor_email_new ve
JOIN vendor_new using (email)
WHERE sent_email is null