Can someone help me with a PHP regular expression to check the following condition at the beginning of a string:

[LEFT [OUTER] | INNER]  JOIN where [] represents optional.

something to match the following

left outer join

left join

inner join

join

 Thanks

Try:

^((left(\s+outer)|inner)\s+)?join\b

Susan

Thanks works great.

With one small modification: 

((left(\s+outer)?|inner)\s+)?join\b

Aussie?? are you an Australian?

Sorry - I missed the '?' when I transcribed the pattern from the test platform.

And yes - I am an Australian (now - originally a New Zealander)

Susan