J
jhun
I do the matching of two tables, what I'm trying to be solve is how to
display of all the contents of source table even without matching with
another table but calculate the flag into 1 for those unmatch key. look at my
code above
table 1 (source table)
class txtid key flag
2101 10 11111
2102 15 22222
2103 20 33333
table 2 (other table)
key elev
11111 10
55555 20
66666 30
the result I want is
class txtid key flag
2101 10 11111 1
2102 15 22222
2103 20 33333
SELECT table1.TXTID
FROM table1 left JOIN table2 ON table1.KEY = table2.KEY
WHERE (((table2.KEY) Is Null));
In this code, display only the unmatch key.
thanks in advance
display of all the contents of source table even without matching with
another table but calculate the flag into 1 for those unmatch key. look at my
code above
table 1 (source table)
class txtid key flag
2101 10 11111
2102 15 22222
2103 20 33333
table 2 (other table)
key elev
11111 10
55555 20
66666 30
the result I want is
class txtid key flag
2101 10 11111 1
2102 15 22222
2103 20 33333
SELECT table1.TXTID
FROM table1 left JOIN table2 ON table1.KEY = table2.KEY
WHERE (((table2.KEY) Is Null));
In this code, display only the unmatch key.
thanks in advance