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
Any idea why?
Table issues, the table can't be populated with the data imported from another db
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?