[SQL] How update a table within a join efficiently ?

2009-07-10 Thread Andreas
Hi, how would I update a table within a join in a more efficient way? E.g. the folowing case: table_a holds abstract elements. One column represents priority which can be based on information of other tables. table_b might hold such details in a column size for about 3000 of 8 records out

Re: [SQL] How update a table within a join efficiently ?

2009-07-10 Thread Pavel Stehule
2009/7/10 Andreas maps...@gmx.net: Hi, how would I update a table within a join in a more efficient way? E.g. the folowing case: table_a holds abstract elements. One column represents priority which can be based on information of other tables. table_b might hold such details in a column