The first syntax situation is the easy part - most people get this part just fine.SELECT FROM [OUTER] JOIN ON