Forum Replies Created
Viewing 15 posts - 1 through 15 (of 67 total)
-
RE: redesigning table to accommodate new data types
ScottPletcher - Monday, February 20, 2017 10:26 AM -
RE: redesigning table to accommodate new data types
ScottPletcher - Friday, April 7, 2017 2:29 PMRE: redesigning table to accommodate new data types
ScottPletcher - Thursday, April 6, 2017 1:17 PMRE: redesigning table to accommodate new data types
ScottPletcher - Monday, February 20, 2017 10:26 AMRE: redesigning table to accommodate new data types
roger.plowman - Wednesday, March 29, 2017 6:49 AMRE: subquery
Thom A - Monday, April 3, 2017 7:30 AMRE: subquery
Thom A - Monday, April 3, 2017 3:54 AMRE: subquery
k i did not explain myself properly.
What I am actually trying to do is this. The query above will give me the subect_id and grade_id for each row in...RE: sql query
thanks. got it!!
is my table design alright?RE: sql query
Home .But i am not getting the desired values. These are the values in the tables.
And when i run the query i get this result.
RE: sql query
k i got it!!! i just didnt know joins worked like this.
select Students.student_rollno, marks, Subjects.subject_name ,Gradetype.Grade_id, TheoryPractical .ThPr_name, EndtermProgressive. ETPA_name
from Students_Subjects_junction
join Subjects...RE: sql query
select Students.student_rollno, marks, Subjects.subject_name ,Gradetype.Grade_id
from Students_Subjects_junction
join Subjects on Students_Subjects_junction.subject_id = Subjects.subject_id
join Students on Students_Subjects_junction.student_pk =students.student_pk
join Gradetype on Students_Subjects_junction...RE: redesigning table to accommodate new data types
thanks everyone for your input.
RE: redesigning table to accommodate new data types
Sean Lange - Friday, March 24, 2017 10:31 AM
