Ernesto
asked on
help with query
hi guys
why this query do not work
INSERT INTO suplementos(numdeord)SELEC T DISTINCT numdeord FROM odc LEFT JOIN suplementos ON odc.numdeord=suplementos.n umdeord WHERE suplementos.numdeord IS NULL
error
ambigous column name
tsm
why this query do not work
INSERT INTO suplementos(numdeord)SELEC
error
ambigous column name
tsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You need to specify where you're getting numdeord from:
INSERT INTO suplementos(numdeord)
SELECT DISTINCT odc.numdeord
FROM odc
LEFT JOIN suplementos ON odc.numdeord=suplementos.n umdeord WHERE suplementos.numdeord IS NULL
INSERT INTO suplementos(numdeord)
SELECT DISTINCT odc.numdeord
FROM odc
LEFT JOIN suplementos ON odc.numdeord=suplementos.n
Try:
INSERT suplementos ( numdeord )
SELECT odc.numdeord
FROM odc LEFT JOIN suplementos
ON odc.numdeord = suplementos.numdeord
GROUP BY odc.numdeord
HAVING COUNT( suplementos.numdeord ) = 0
Saludos
INSERT suplementos ( numdeord )
SELECT odc.numdeord
FROM odc LEFT JOIN suplementos
ON odc.numdeord = suplementos.numdeord
GROUP BY odc.numdeord
HAVING COUNT( suplementos.numdeord ) = 0
Saludos
That's because numderord exists in both odc and suplementos tables, and T-SQL doesn't know which one you want to insert, and won't assume for you.
INSERT INTO suplementos(numdeord)SELEC
or
INSERT INTO suplementos(numdeord)SELEC