Code: Select all
INSERT INTO "CaseLabels"
("CaseLabel",
"DiscDescription"
)
SELECT "MovieTitle" AS CaseLabel,
"MovieDescription" AS DiscDescription
FROM "Films"
WHERE "MovieTitle" LIKE 'M*A*S*H*' AND
"Length" IS NULL
ORDER BY "MovieTitle" ASC
--Removed the aliases on the SELECT statement
--Removed the ORDER BY clause
--Added table names to all fields
--Made sure that the data types of the fields (source and destination) are the same
--Executed the SELECT portion separately (which does show results)
Based on looking at several SQL sites, I am believe the overall syntax is correct. I use similar code to essentially duplicate records in one table and that works fine. This is the first time I have tried to use two tables.
If it matters, this is using an Embedded database file.
Are there any thoughts on why the code seems to execute, but not produce results?