Kirk Wythers <kwythers@xxxxxxx> writes: > The new table needs to be filled with the results of the join. If > there is a way to do this without a SELECT, please share. If it's an entirely new table, then you probably want to use INSERT ... SELECT. If what you want is to update existing rows using a join, you can use UPDATE ... FROM (not standard) or something involving a sub-select. You'd need to state your problem in some detail to get more help than that... regards, tom lane
