App development

[sridhar423]

Hi All,

I have two tables.I loaded the two tables ,after concatenating i have a table that consists of Lotno and Prod.Actually Lotno 1 has two Prod A and D.But when i select  "1"  i need to get the Prod A only.if the two tables contains same Lotno priority should be given to Table1 only.

        Table1 

Lotno	Prod
1	A
2	B
3	C

    Table2

Lotno	Prod
1	D
3	E
5	F

Thanks

Sridhar.

[Anonymous]

Hi Shridhar,

Attached is a sample app for solution

[sridhar423]

Hi Bhagirath,

I saw ur attachment but it is complex.After some trials i got the solution.

By using Exists function we can get the answer what i post in the earlier one.

try using Where not exists.

Thanks

Sridhar.

[Anonymous]

mine was one of the solutions and not the only solution.