Need a wee bit o' SQL help

[jazaddict]

Hi.
This works, but it returns duplicates
"INSERT INTO tblTargetAdd ( targetID ) SELECT * FROM Target WHERE (((Target.targetID)=" & Int(Me!lstAddACFT) & "));"



THis eliminates the duplicates, but I can't seem to get it incorporated into the previous query

SELECT target.targetID, Target.Name,Target.RSI FROM Target WHERE (((Target.RSI)="31101")) group by Target.Name,Target.RSI,TargetID;

can one of you whiz-bang SQL-ers help me get the append query to ONLY append 1 copy of each?

I can tell you that neither this

INSERT INTO tblTargetAdd ( targetID ) SELECT * FROM Target WHERE target.targetID, Target.Name,Target.RSI IN (SELECT target.targetID, Target.Name,Target.RSI FROM Target WHERE Target.RSI="31101" group by Target.Name,Target.RSI,TargetID);



nor this




INSERT INTO tblTargetAdd ( targetID ) SELECT * FROM Target WHERE target.targetID IN (SELECT target.targetID, Target.Name,Target.RSI FROM Target WHERE Target.RSI="31101" group by Target.Name,Target.RSI,TargetID);



Work. Thanks

[danlefree]

Have you tried the LIMIT directive?

SELECT target.targetID, Target.Name,Target.RSI FROM Target WHERE (((Target.RSI)="31101")) group by Target.Name,Target.RSI,TargetID LIMIT 1;

[jazaddict]

Hi danlefree,
Thanks for takin the time to respond.
I should have mentioned I'm using MS Access in which there is no LIMIT keyword.

However,I got it to work as follows:

INSERT INTO tblTargetAdd
SELECT *
FROM Target
WHERE TargetID in (SELECT targetID FROM Target WHERE RSI="31101");


It only took 2 days of head-scratching to find what turned out to be a SIMPLE solution

[jazaddict]

Well.....I've apparently lost my mind.
The previous does NOT work as it still gives me dupes.....but "limit" doesn't exist in Access so I'm back to square 1.

[danlefree]

This might be what you're looking for:

MYSQL
"SELECT ... WHERE ... LIMIT N"

MS Access
"SELECT TOP N WHERE ..."

[danlefree]

Did the top directive end up working out for you ..?