jethro.njini 0 Newbie Poster

i have recently created a database with three tables and the fourth one is a junction table that links all these tables. i want to know how to retrieve data represented by the foreign keys in the junction table using jsp(if it is possible, if it is not, how do i display this data, i am developing a java web based application). the tables are
1. Training - rows: tr_id(pk), tr_duration, tr_name
2. Training_dates - rows: tr_date_id(pk), tr_sdate, tr_edate, tr_venue
3. Employee_details - rows: emp_id(pk), phone_number, etc
4. JNCT_epm_tr - rows: JNCT_epm_tr_id(pk), tr_fk(fk), tr_dates_fk(fk), emp_fk(fk)
i want to display data in the other three tables that is represented by those foreign keys in the junction table(JNCT_epm_tr).can anyone help? thank you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.