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]