affected columns

2003-07-29 Thread Carlo Loiudice
HI, is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose. Someo

is it a many-to-many?

2001-11-14 Thread Carlo Loiudice
Hi, I'm Carlo and I've this question: I've 2 tables, with this structures: Table1: product Table2: measures 1) ID 1) ID 2) weight 2) symbol 3) ID_weight_measure 4) height 5) ID_height_measure OK. Is there a way to obtain with a single select statement bot