Selasa, 28 April 2015

[MS_AccessPros] NOT IN condition

 

Inside the NOT IN condition of the WHERE clause of the production database contains like 200 'AcctNumber'. e.g. NOT IN('1','2','3','4','5'.... and more).

 

I am wondering if there is a better way to code it, like, create a separate table instead of place the AcctNumber in side the parenthesis?

 

Phucon

__._,_.___

Posted by: saigonf7q5@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar