Hello everybody

I have a table TableA with the following data:

LINE  USED
  1        F
  2        F
  3        F
 95       F
 96       F

and a table TableB with the following data:

LINE
  1
  2
  3
  4

and I need to put a 'T' on the USED column when the line's number is the
same in both tables (in this case, when it is 1, 2 or 3). Of course, there
are much more numbers and I dont know them.

How I can make an update on TableA when it has the same numbers that TableB
has? I need this result:

TableA
---------
LINE  USED
  1        T
  2        T
  3        T
 95       F
 96       F

Thanks in advance.

Walter.


[Non-text portions of this message have been removed]

Reply via email to