Combine two tables based on the first table records

manpreet Best Answer 2 years ago

I have two tables like this,

  Class  |  Name     | Unit  | Year
 --------+-----------+-------+--------
  10th   |  Language |  2    | 2014
  10th   |  Maths    |  3    | 2014

Second table,

      Name  | Title | Period | Syllabus
  ----------+-------+--------+-----------------------------
   Language |Unit1  | 8      | Subject1, Subject2, Subject3
   Language |Unit2  | 9      | Subject4, Subject5, Subject6
    Maths   |Unit1  | 7      | Subject1, Subject2, Subject3
    Maths   |Unit2  | 8      | Subject4, Subject5, Subject6
    Maths   |Unit3  | 9      | Subject5, Subject6, Subject7

And the result Should be,

      Language

      Title | Period | Syllabus
    ----------------------------------
     Unit1  | 8      | Subject1, Subject2, Subject3
     Unit2  | 9      | Subject4, Subject5, Subject6

      Maths

      Title | Period | Syllabus
    ----------------------------------
     Unit1  | 7      | Subject1, Subject2, Subject3
     Unit2  | 8      | Subject4, Subject5, Subject6
     Unit3  | 9      | Subject5, Subject6, Subject7

Second table result is base on the first table name..

Can anyone help me in python with mysql? i'm very to python..

manpreet 2 years ago

--To get language details:
SELECT title, period, syllabus
FROM Second
WHERE Name = 'Language' --replace language with Maths here to get maths subject details

--To get details from table1 and table2
SELECT s.title, s.period, s.syllabus, r.year
FROM Second s INNER JOIN First f
ON f.Name = s.Name
WHERE Name = 'Language' --replace language with Maths here to get maths subject details