Join

[#1]

Suppose i have two tables

Table 1

A 

1

2

3

4

5

6

ans Table 2

B

5

6

i want to join the two tables so that my table contains values that are not in Table 2 but are present in Table 1

i.e

A

1

2

3

4

CAn any one help me for this through Joins ....

[#2]

Hi,

You can use the function Exists(), attached is an example

Hope this helps

Regards!