Excellent Svein, it works!!!

Thank you very much.

Walter.

On Wed, Oct 5, 2011 at 3:14 AM, W O <sistemas2000profesional@...>wrote:

> Thank you very much Svein, I'll try it now.
>
> Greetings.
>
> Walter.
>
>
>
>
> 2011/10/5 Svein Erling Tysv�r <svein.erling.tysvaer@...>
>
>> **
>>
>>
>> >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?
>>
>> Hi Walter,
>>
>> UPDATE TableA TA
>> SET TA.USED = 'T'
>> WHERE EXISTS(SELECT * FROM TableB TB
>> WHERE TA.LINE = TB.LINE)
>>
>> Set
>>
>>
>>
>
>


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