Hi Guys,
In a nutshell i have 3 tables
Students - contains the main details e.g name, D.O.B, address, contact
Sciences - contains 4 science subjects physics,chem,bio maths
arts - contains 4 art subjects literature,history,politics,international studies
for the last 2 tables each student has a grade so if for a particular studentID i run a Select query it produces all contents of Students,sciences and arts...
i want to produce a report that displays all student details, the 4 subjects from Sciences and Arts together with the grades...without any duplications
currently i have this query:
SELECT *
FROM STUDENTS, SCIENCES,ARTS
this query produces too many duplicate rows...
how can i restrict the report to give only the unique records
In a nutshell i have 3 tables
Students - contains the main details e.g name, D.O.B, address, contact
Sciences - contains 4 science subjects physics,chem,bio maths
arts - contains 4 art subjects literature,history,politics,international studies
for the last 2 tables each student has a grade so if for a particular studentID i run a Select query it produces all contents of Students,sciences and arts...
i want to produce a report that displays all student details, the 4 subjects from Sciences and Arts together with the grades...without any duplications
currently i have this query:
SELECT *
FROM STUDENTS, SCIENCES,ARTS
this query produces too many duplicate rows...
how can i restrict the report to give only the unique records
