How do I fetch the id from one table and from that id ihave to fetch all the data from another table

Question

0.00/5 (No votes)

See more:

i have two tables one is job table and other is resume table.i want to fetch resume against every job record. i have job id in resume table as jid. Means a person can post many resumes against many jobs.so, how can i list all the jobs and resume one person posted.Note: i also have users table. <a href="https://i.stack.imgur.com/XiqsY.png"></a>[<a href="https://i.stack.imgur.com/XiqsY.png" target="_blank" title="New Window">job table pic</a>] and <a href="https://i.stack.imgur.com/KzKwX.png"></a>[<a href="https://i.stack.imgur.com/KzKwX.png" target="_blank" title="New Window">resume table</a>] 
and my point is to show the records as
<pre lang="text">
    ------------------------------------------------
     my job posted job |   resumes against that job |
    -------------------|----------------------------|
     job1              |   resume1                  |
                       |                            |
    ------------------------------------------------

What I have tried:

i have tried much but im new too db so can you please help all?

Posted 14-Apr-17 21:14pm

Hamza Razzaq

Updated 16-Apr-17 22:00pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2017-04-14T21:35:00

Solution 1

Use an SQL JOIN:

SQL

SELECT u.*, j.*, r.* FROM Jobs j
JOIN Resumes r ON j.ID = r.jid
JOIN Users u ON u.ID = i.uid
WHERE u.ID=3

Posted 14-Apr-17 21:35pm

OriginalGriff