View criteria help required please

View criteria help required please

Can anyone help with the following with regards to setting criteria for a view.

The following statement works fine and restricts the view to show only records where field "Load_ID.Status" is null and also where field "Status" is null...

show  all  rows  from  Create_Pallets [(Load_ID.Status is null) && (Status is null)]

I need to add another criteria to further restrict the view to show only records where, in addition to the above, field "Client.Company" contains either "word_a" or "word_b"

I've tried the following but the statement fails...

show  all  rows  from  Create_Pallets [(Load_ID.Status is null) && (Status is null) && (Client.Company == "word_a" or "word_b")]

Any ideas would be greatly appreciated.

Thanks.