I don't know why, but the SQL bundle wouldn't highlight "JOIN" as a keyword. It seems to have all of the other variants.
Index: Syntaxes/SQL.plist =================================================================== --- Syntaxes/SQL.plist (revision 11005) +++ Syntaxes/SQL.plist (working copy) @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="UTF-8"?> -<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd "> +<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd "> <plist version="1.0"> <dict> <key>fileTypes</key> @@ -229,7 +229,7 @@ </dict> <dict> <key>match</key> - <string>(?i:\b(select(\s+distinct)?|insert\s+(ignore\s+)?into| update|delete|from|set|where|group\sby|or|like|and|union(\s+all)?| having|order\sby|limit|(inner|cross)\s+join|straight_join|(left|right) (\s+outer)?\s+join|natural(\s+(left|right)(\s+outer)?)?\s+join)\b)</ string> + <string>(?i:\b(select(\s+distinct)?|insert\s+(ignore\s+)?into| update|delete|from|set|where|group\sby|or|like|and|union(\s+all)?| having|order\sby|limit|(inner|cross)\s+join|straight_join|(left|right) (\s+outer)?\s+join|natural(\s+(left|right)(\s+outer)?)?\s+join)\b| join)</string> <key>name</key> <string>keyword.other.DML.sql</string> </dict>
-- Jacob Coby