Help Please
 

my language is blackberry cascade.. Im using sql db. Im working with BB10 simulator

and I need to create 2 table like

Student and Subjects

where I have.. Student_id and Student_name in Student

and Subject_id and Subject in Subjects.. the relationship will be like:

Select distinct Subject from Student,Subjects where Student_id = Subject_id

It will be like a list of student when I click one the Subjects will be displayed.. on that page or in another page..

I appreciate If you could give me a sourcecode and Im willing to participate and help u in another matters.. I also appreciate another language for blackberry..