CODEWITHSUNDEEP
sqlmyob
luk
luk

Reputation: 23

SQL for Multiple Account names - MYOB

This is what i have got so far.

A.ACCGROUP=1

This works to show only accounts in region #1. but i would like to be able to see regions #1, 12 & 18 at the same time. This is for the custom filters within MYOB accounting software.

Is this possible, Thank you in advance

I have tried A.ACCGROUP='1' AND '12' but got an error.

Upvotes: 1

Views: 135

Answers (1)

mrtig
mrtig

Reputation: 2267

Have you tried this?

A.ACCGROUP IN (1, 12, 18)

Upvotes: 2

Related Questions