eliminating rows from a return set - join problem

[Steve_LL]

I don't understand what you're asking. Is it how to isolate the row? If so, you have to make sure that the tables are joined properly and select the values that make the row unique...

select *
from links2 l inner join links_linkTypes2 t on l.linkID = t.linkID
inner join linkTypes2 lt on t.linktypeID = lt.linktypeid

where l.linkID = '1198'
and lt.type = 'Eugene'

to delete the row:

delete
from links2 l inner join links_linkTypes2 t on l.linkID = t.linkID
inner join linkTypes2 lt on t.linktypeID = lt.linktypeid
where l.linkID = '1198'
and lt.type = 'Eugene'

Does that help?