hi friends
i want to use multiple queries an APPEND clause. I used the following code but it gives syntax error. plz help me as soon as possible.


rs.Open "Shape {SELECT DISTINCT sem From qAwd WHERE seat_no=" & stno & " AND class= '" & deg & "' ORDER BY sem} As Parent Append (({Select crs_title, crs_no, cr_hrs, lab, midterm, terminal, total_marks, total, crs_index, remarks, sem, ayr From qAwd WHERE seat_no=" & stno & " ORDER BY sem, crs_no, exm_date} Relate sem To sem) As com1) Append (({Select total, sem From qAwd WHERE seat_no=" & stno & " AND remarks='" & passStudetn & "' ORDER BY sem} Relate sem To sem) As com2)", con, adOpenStatic, adLockReadOnly, adCmdText