Multiple table Query-HELP
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.
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