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