Classic ASP, check is recordset exists/matches on the second table

See more:

ASP

Hi There

I am a newbie to this

I need a bit of help from you guys!
have two tables rsletters and rscheck
i would like to check if dbo.rsletters.eletter_id exists in dbo.rscheck.p_letter_id
if it does exist to say "it exists"
if it does not exit say "nowhere to be seen"

the page has a recordset rsletters which is filtered by eletter_id

How do i do this

regards
vitor

What I have tried:

<%if (((rsletters.Fields.Item("eletter_id").Value)) = ((rscheck.Fields.Item("p_letter_id").Value))) then
%>
<%end if %>