Skip to Content
0
Former Member
Jun 29, 2009 at 05:31 PM

SQL - Select a constant

50 Views

Hello people,

I have a function that receives a table as a parameter.

I need to check if each enter in this table exists in table in database. If it exists, I need to mark "X" in the last column in this table. Liek this:

SELECT WERKS MATKL 'X'

INTO CORRESPONDING FIELDS OF TABLE T_LISTA

FROM yswerks_matkl

FOR ALL ENTRIES IN T_LISTA

WHERE WERKS = T_LISTA-WERKS

AND MATKL = T_LISTA-WERKS.

Is it possible?

Thanks a lot!