Retrieve information from 2 tables using sql command. so i have two tables "attendance" & "grade" . as you can see from the picture first one is the attendance table and second one grade table . i want to get the student id and first name from these tables where student grade = c,d,f (i dont want to display anyother student with any other grade) and absenses greater than 2 . what is the sql command i can type inorder to retrieve this information in a table form.

this was my attemt lol - "select student_id, first_name from grade,attendance where Grade = 'C', 'D','F' & absences => 2 "

first name last name student id class name Date 2016-02-25 3 2016-02-26 7 2016-02-27 3 2016-02-28 7 2016-03-25 7 2016-03-26 7 2016-04-25 7 2016-04-26 3 2016-04-27 7 016-04-29 7 Total Roy Science 43621 Math 3362 3 Art 2301 Spanish 2301 7 Science 4362 1 Math 3362 4 Science 4362 2 Math 3362 2 Art 2301 History 2342 7 Sharon Sharon Roy 2 Sharon Roy