Comparing tables

[razaqtelecom]

Hi,

I want to know how can i write a stored procedure for the following sceario.

Take if there are three tables, table1, table2, table3 and table1 is linked with table2 and table 2 is linked with table3.

Now i have to compare a data in table 3 for one of the rows in table1 where as For the same row in table1 there will 100 rows in table 2 and for each row in table2 there will be 100 rows in table 3.

So I need to write a stored procedure to compare the data in table 3 with some value and throw execption.

I will give u rows of all the three tables;


Tabel1

tag

name

date

expirydate


Table 2

tag

table1_tag

name

expirydate



Table3

tag

table2_tag

name

status

date

expiry


Now I have to compare the status of table 3 with values 0 and 2 and throw error.

Can u please send me stored procedure for the above scenario

Thanks and Regards
Abdul Razak

[razaqtelecom]

Please reply for the below mail its urgent please..................................

Hi,

I want to know how can i write a stored procedure for the following sceario.

Take if there are three tables, table1, table2, table3 and table1 is linked with table2 and table 2 is linked with table3.

Now i have to compare a data in table 3 for one of the rows in table1 where as For the same row in table1 there will 100 rows in table 2 and for each row in table2 there will be 100 rows in table 3.

So I need to write a stored procedure to compare the data in table 3 with some value and throw execption.

I will give u rows of all the three tables;


Tabel1

tag

name

date

expirydate


Table 2

tag

table1_tag

name

expirydate



Table3

tag

table2_tag

name

status

date

expiry


Now I have to compare the status of table 3 with values 0 and 2 and throw error.

Can u please send me stored procedure for the above scenario

Thanks and Regards
Abdul Razak