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]