Where Clause

[Anonymous]

Hi Guys

I am trying to do a where clause with the following

where client_group_id <> '78' or '7' and statement_ref <> '512'

It is not working any ideas what i am doing wrong?

Thanks

[Chanty4u]

where ur using this?

and  what error ur getting?

and did u chkd with the case  field names?  upper or lower?

[Digvijay_Singh]

Not sure but see this works -

where (client_group_id <> '78' or '7') and (statement_ref <> '512')

[sunny_talwar · Accepted solution]

May be this:

Where not Match(client_group_id, 78, 7) and statement_ref <> 512;

[sunny_talwar]

Digvijay‌ this probably won't work because if you use or, you need to add client_group_id the second time

where (client_group_id <> '78' or client_group_id <> '7') and (statement_ref <> '512');

[Digvijay_Singh]

Or

where (client_group_id <> '78' or client_group_id <> '7') and (statement_ref <> '512')

See if first OR needs to be AND in case

[Digvijay_Singh]

Ya, realized just after posting

[Anonymous]

Thanks Sunny

Tried the others but this managed to work for me

Thanks again!

[Anonymous]

Digvijay Thanks for help!