neolempires2@gmail.com wrote:

> hi..i'm new in sql progaming,
> i try to make make a query that in table field "match" return to "1"
> if no member record in another table and return to "0" if there is any
> record member :
>
> ex
> table member:
> member id
> A 12
> B 14

You have a table and a column of that table with the same
name? Eww, fix that.

> Table Incoming.
> member note match
> C bla..bla 1
> A bla..bla 0
> D bla..bla 1

Assuming that the Incoming table already has rows with correct data
in all columns except possibly 'match':

update Incoming
set match = 0
where member in (select member from member)

update Incoming
set match = 1
where member not in (select member from member)