There is no sorting or union involved in your query. You are asking for all the rows in table 1 where the course_id is in table 2 with classID = 1. There are only two rows in table 1 and therefore at most two rows in the output.

Assuming there are actually other columns in table 1 then what you want is a join.
Qt Code: 
  1. SELECT table1.* 
  2. FROM table1 INNER JOIN table2 
  3. ON table1.courseID = table2.courseID
  4. WHERE table2.classID = 1
To copy to clipboard, switch view to plain text mode 
If there are no other columns in table 1 then you don't need that table at all.
Unless you explicitly apply some sort order to the data there are no guarantees about the order of the output, though usually you get them in the order they were inserted.

If you wish to transpose the rows and columns from the model then you should either:
  • Use a proxy model to transpose the data. There's an example [wiki]Transpose Proxy Model[/wiki] in the wiki.
  • Use a more complicated query to extract the data that way, but this comes with lots of limitations.