Recent content by chrisz

Good point. Ignore it then. Thanks for your advice. I'll look elsewhere. :-)

Hi, I wish to update one column in a table , with one column from TWO MULTI-ROW tables. I can't do it without setting a rownum of 1, to force the update to select only row one from each table. Whereas I want ALL rows from both tables added together and stored onto the one row in the...