Jeff,
I did not spot any problem with your statement,
so my only thought is to change your statement
into a SELECT so you can see the multiple row
condition.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Wednesday, August 22, 2012 8:12 AM
To: Midrange Systems Technical Discussion
Subject: Help with SQL Update using join files
I have the following SQL statement:
update vinbini set baqcm = (select ifqcm from vinitmb join vinbini on bacmp = ifcomp and baloc = ifloc and baitem = ifitem
where ifqcm <> baqcm and babloc = 'WHS') where exists (select 1 from vinitmb join vinbini on bacmp = ifcomp and baloc = ifloc and baitem = ifitem
where ifqcm <> baqcm
and babloc = 'WHS' )
Where file vinitmb is unique at the company/location/item level and vinbini is unique at the company/location/item/bin level.
I want to update a field in vinbini for the 'WHS' bin records only when the committed qty in vinitmb does not equal the value in vinbini.
I am receiving the Result of SELECT more than one row message.
What am I missing?
Thanks,
--
Jeff Young
Sr. Programmer Analyst
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
