var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update field in table
Hi everyone, I'm back..
Need the correct syntax to update a field in one table getting data from a field in another table.
Problem is the tables must be joined on two fields..
This is what I do:
set ekptp=(select discount.discount from discount
where bksyp.isbne=discount.isbne and
(bksyp.isbne in (select discount.isbne from discount) and
bksyp.ypkod in (select discount.ypkod from discount))
This updates more records than needed..
There must be something wrong in the last part I believe.
Last edited by Themis; 02-01-05 at 12:32.