-->>Hello I hope all is well.
-->>I'm trying to join or select some data from 5 tables by using the following join statement:
SQL ="SELECT RegistrationTB.Christian_Name,RegistrationTB.Father_Name,RegistrationTB.Birth_Date,"
"BaptismTB.Date_Baptised,BaptismTB.Parish_Name,BaptismTB.Minister_Name," & _
"CommunionTB.Date_Communised,CommunionTB.Parish_Name," & _
"ConfirmationTB.LC_No,ConfirmationTB.Date_Confirmation,ConfirmationTB.Parish_Name,ConfirmationTB.Minister_Name," & _
"MarriageTB.LM_No,MarriageTB.Date_Married,MarriageTB.Parish_Name,MarriageTB.Mr_Name,MarriageTB.Mrs_Name,MarriageTB.Certificate_No,MarriageTB.Minister_Name " & _
"FROM RegistrationTB " & _
"INNER JOIN BaptismTB ON RegistrationTB.LB_No=BaptismTB.LB_No " & _
"INNER JOIN CommunionTB ON BaptismTB.LB_No=CommunionTB.LB_No " & _
"INNER JOIN ConfirmationTB ON BaptismTB.LB_No=ConfirmationTB.LB_No " & _
"INNER JOIN MarriageTB ON BaptismTB.LB_No=MarriageTB.LB_No " & _
"WHERE ((LB_No) = '" & txtLB_No.Text & "');"
-->>But what I get is a Syntax error (missing operator) in query expression.
-->>Please help.