• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 28
  • Last Modified:

Easy Firebird question

Hello, i hope my question is not to stupid, but i have sometimes to deal with our firebird database and just need quick help:

How to update values with a join condition:

"
select Vauftragnr, Kundname, Lager from wws_verkauf1
join wws_verkauf2 on wws_verkauf1.VAUFTRAGNR = wws_verkauf2.VAUFTRAGNR
where artikelnr="30000" and datum>"01.01.2018" and erledigt="N"
"

i would like to update the "Lager"
0
Robert Hasitschka
Asked:
Robert Hasitschka
1 Solution
 
Omar SoudaniSystem Support EngineerCommented:
0
 
PortletPaulfreelancerCommented:
Firebird does not support joins in an update statement. You need to locate the wanted rows to update using the where clause instead. E.g. by using EXISTS

Before I could try a rewrite I would need to know which tables these columns come from:

where artikelnr="30000" and datum>"01.01.2018" and erledigt="N"

nb It is really important to preface columns by the table in any multi-table query.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now