Could you tell me why I set here where can't achieve in the terms?

CodePudding user response:

Is the where in the condition that the student TAB, to label the eligible filtered, table 1 is a DF, table 2 is DFCOND, DFCOND. Enr_cond is the student table tags.

CodePudding user response:

To this:
LEFT the JOIN DFCOND ON DF. DFKEY=DFCOND. SKEY AND DFCOND. ENR_COND IN
12 '(',' 6 ', '13'... )