I have a table named CLIENTE_PRODUCTO with the following fields:
ID_CLIENTE_PRODUCTO (PK): Autonumeric
COD_CLIENTE: Text
CODIGO_RAMO: Text
FECHA_VENCIMIENTO: Date
PRIMA: Numeric
And I am trying to run this append query:
Code: Select all
INSERT INTO CLIENTE_PRODUCTO ( COD_CLIENTE )
SELECT "222" AS Expr1;
As you have seen in the table description, COD_CLIENTE is not the table PK, however it is the PK in a different table but that table is not mentioned in the query.
I have tried with
Code: Select all
SELECT '222' AS Expr1
Code: Select all
SELECT 222 AS Expr1
What am I missing?
Thanks!