Answer the question
In order to leave comments, you need to log in
What is wrong with join request?
SELECT "LE 2015" as Year, Month, Responsible, Price
from Budget
where Year="2015"
UNION
ALL
SELECT "LE 2015" as Year, Month, Responsible, Price
from Budget
where Year="2015"
query where Year="2015"
Answer the question
In order to leave comments, you need to log in
Try option
SELECT [LE 2015] as Year, Month, Responsible, Price
from Budget
where [LE 2015] ="2015"
UNION ALL
SELECT [LE 2015] as Year, Month, Responsible, Price
from Budget
where [LE 2015] ="2015"
INSERT INTO Budget ( [Year], [Month], Responsible, Price )
SELECT "LE 2015" as Year, Month, Responsible, Price
from Budget
where Year="2015"
UNION ALL
SELECT "LE 2015" as Year, Month, Responsible , Price
from Budget
where Year="2015"
Sorry, the inner part of the query without an insert works fine, when I add an insert, it gives an error.
Who can tell why?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question