Guys I have a database looking something like this,
PartNo Description 111 Hello 123 Hello 456 World 123 Hello I want to detect the first occurrence of a given PartNo (say 123) and delete the whole row from the DB So for example I want to delete the row "123 Hello" given the PartNo 123 I guess its SQL but I am not too sure what to do Any ideas? Many thanks Julian Holt [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor ---------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/k7folB/TM ---------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
