obtaining the result from three different tables

Question

1.00/5 (1 vote)

See more:

i have three different tables,

course no Course name - table1

paper id paper name - table2

Course no Paper id - table3

how do i get the corresponding paper names using the course id?

Posted 23-Aug-12 20:00pm

codingisok101

Add a Solution

Comments

ssd_coolguy 24-Aug-12 2:02am

what you have tried?

codingisok101 24-Aug-12 2:04am

Select CourseName,PaperName from Table1,Table2 where table3.courseno=table1.courseno;

Kuthuparakkal 24-Aug-12 2:35am

Go to W3school and learn SQL joints:
http://www.w3schools.com/sql/sql_join.asp

there is some standard we expect from questions.

2 solutions

Solution 1

SQL

SELECT tb2.paperName
FROM 
table2 as tb2
INNER JOIN
table3 as tb3
WHERE tb2.paperID = tb3.PaperID
AND tb3.CourseNo = --Any value

You are not following naming conventions properly.
Please try to implement that and name your tables and fields properly.

Posted 23-Aug-12 20:06pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ssd_coolguy · Accepted Answer · 2012-08-23T20:06:00

Solution 2

try below code...
if you want only course no ans paper name..

SQL

select table3.course_no,table2.paper_name
 from table2 inner join table3
on table2.Paper_id=table3.Paper_id
where on table3.course_no= '2'

Posted 23-Aug-12 20:06pm

ssd_coolguy

Updated 23-Aug-12 20:08pm

v2

Comments

codingisok101 24-Aug-12 2:14am

so is table1 not required?

ssd_coolguy 24-Aug-12 2:19am

you asked for course_no and paper_name
if you want course name then it requires table1..

obtaining the result from three different tables

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

obtaining the result from three different tables

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us