Skip to Content
0
Former Member
Feb 26, 2009 at 08:50 AM

how to write select statement between two tables

26 Views

hi,

i need to do comparision between two table for each records.ex:

table1:

regid regno ind

1 1001

1 1002

1 1003

1 1004

and table2:

regid regno

1 1002

1 1005

i need to select first row from table and loop for values in second table, if the values found first record , the record must update 'yes' to ind, if not 'No'.

please help with this.

thanks in advance

raja