Hi all!

I have an ASP page where the user enters the SSN than I query 4 tables (MAST,S1MMARY,S1UDREC,N1TEREC) that all have the field SSN in them. We use dbase, so there are no Auto-assigned numbers in these tables which is why I use SSN.

Table Fields
MAST DOB,SID,FIRSTADD
S1MMARY LNAME,FNAME,TRANSF
S1UDREC CR
N1TEREC CR

In S1UDREC and N1TEREC there will me multiple entries for that SSN. They will need to be added together, not sure how to do that.

The following is the sql string I am using. When I try to display it, it comes back "False"? With no Sql string.

"SELECT S1MMARY.SSN,MAST.SSN,S1UDREC.SSN,N1TEREC.SSN,S1MMA RY.LNAME AS LNAME,S1MMARY.FNAME AS FNAME,S1MMARY.TRANSF AS TRANS,MAST.DOB AS DOB,MAST.SID AS SID,MAST.FIRSTADD AS INITDATE,S1UDREC.CR AS CR1,N1TEREC.CR AS CR2 FROM MAST JOIN S1MMARY ON(MAST.SSN = S1MMARY.SSN)JOIN S1UDREC ON(S1MMARY.SSN = N1TEREC.SSN)JOIN N1TEREC ON(S1UDREC.SSN = N1TEREC.SSN) WHERE MAST.SSN='" & strSSn & "'"



Thanks for any help


Kathryn

Ended up using multiple sql statements.

Kathryn