I have a query that takes two tables (join) and does something on it. Lets say these tables are A and B. What I need is that everytime one of the tables (A) has its rows selected, I want to update the count (which is a column in A) for that row. I am not sure what is the best way to do this. 1)I could create a dummy view and do a RULE on that (I am not sure how to get access to the row's that have been selected). 2) I could create a storedprocedure. Get all the rows to be returned and then, loop through the rows and update the column and then return it. Q1) Which way is better? q2) How does one get access to the rows just selected in the CREATE RULE computation? thanks. -assad
