Select query from mysql database

Question

Hello I am having a hard time trying to SELECT all of the information I need from two tables, the following two tables are:

Person: |id|fname|mname|lname|   and Related: |id1|id2|relationship|

and I want the following to be displayed back from the SELECT query:

|id1|fname(of id1)|id2|fname(of id2)|relationship|

SO the Related table has two id's that are FOREIGN KEYS to Person(id), and I need to SELECT id1, (id1's first name), id2, (id2's firstname), and the relationship.

I've tried something like this and a few other SELECT queries but I can't seem to get it to work:

SELECT p.fname, r.id1, r.id2, r.relationship
FROM Person p, Related r
INNER JOIN Related ON first.id = r.id1 
INNER JOIN Related ON second.id = r.id2;

Any help will be greatly appreciated! Thank you!

Explosion Pills · Accepted Answer · 2013-04-30 04:01:07Z

1

You're joining on Related thrice. You only need to join once, and you need to join on Person again.

SELECT id1, p1.fname, id2, p2.fname, relationship
FROM Person p1
JOIN Related ON (p1.id = id1)
JOIN Person p2 ON (id2 = p2.id)

answered Apr 30, 2013 at 4:01

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Baraa Over a year ago

Thank you very much this worked it will be the accepted answer as soon as I can accept!

Max · Accepted Answer · 2013-04-30 04:01:26Z

0

I've found a website for you (w3schools) and it should have all the information you need for the SELECT function you're trying to get. Hope this helps: http://www.w3schools.com/php/php_mysql_select.asp

answered Apr 30, 2013 at 4:01

Max

1651 gold badge6 silver badges24 bronze badges

1 Comment

Baraa Over a year ago

Yeah I actually know w3schools and I have searched through things and I've done other queries that worked based upon things I learned from there...but this query I just couldn't get to work but thanks for the info!

Collectives™ on Stack Overflow

Select query from mysql database

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related