Table issues, the table can't be populated with the data imported from another db

Learn SQL Coursera
,
1

Hi!
I can’t populate my table “items” (zen DB) with the data from the table products. I use this query:
INSERT INTO “items”
(SELECT productid, concat(supplierid, categoryid,discontinued),
productname, unitsinstock, unitprice
from “products”);
Any idea why?

2

Hi there!

Could you please share the error that you are seeing when you run the query in question?

Could it be the case that the items table and products table have different schema definitions?