Question two different tables in crystal report

boknat

Member
Joined
Oct 4, 2011
Messages
9
Programming Experience
Beginner
hi i am learning crystal report and i have encountered this problem..i want to display two different tables in crystal report i have a query here that select

VB.NET:
SELECT studentprofile.lastname as lastname, studentprofile.firstname as firstname, studentprofile.middlename as middlename, `subject`.subjectname as subjectname FROM `subject` INNER JOIN student_subject ON `subject`.idSubject = student_subject.idSubject INNER JOIN teacher_subject ON teacher_subject.idSubject = student_subject.idSubject INNER JOIN teacher ON teacher_subject.idTeacher = teacher.idTeacher INNER JOIN studentprofile ON studentprofile.idStudent = student_subject.idStudent WHERE  studentprofile.idStudent=1

my query is working, the problem is, in crystal report, i put my lastname, firstname and middlename it displays, but when i put subject name it don't.
i tried to display subjectname only and it display nothin.

how can i solve this problem...thanks...
 
Back
Top