Error message: types are not compatible

[Former Member]

Guys, the coding'd be as blew: and issue an error: The type of "S031~Spmon" or the result type of the function. "S031~Spmon" and the type of "S_ZYEAR" are not compatible for the operation in question.

What should I do?

thanks!

Select - options:
  S_ZYEAR for S031-Spmon.

Select ~
Inner join S031
        on S031~SPMON = @S_ZYEAR.

[abo]

"select option" is just a "range", which is a table with a given structure.

You cannot join on a range, only on a database table.

Perhaps you should use:

WHERE spmon in S_ZYEAR