You can't do it without one other row that has a UNIQUE identifier.
--K
> -----Original Message-----
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 27, 2000 11:59 AM
> To: CF-Talk
> Subject: ot: sql question
>
>
> here's what i'm doing
>
> delete from class_registration
> where users_id='123123'
> and class_id='4242424'
>
> here's what the table looks like
>
> name users_id class_id
> gavin 123123 4242424
> gavin 123123 4242424
> gavin 123123 4242424
> gavin 123123 4242424
>
> what i want to do is delete only 1 of those rows
>
> suggestions?
>
> thanks,
> Gavin
> --------------------------------------------------------------
> ----------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.