1

Is there away to join 3 tables by two attribute names and still display that entire row?

We have 3 tables, sports(event type, team 1, team 2, place, time, date, price) concert(artist, time, date, place, opening act and price) and restaurants(place, name, special and date)

I want to join them with sports.date, concert.date, sports.place, concert.place and restaurant.place

But i want it to show the rest of the attributes in the rest of the rows for each table.

Improve this question
6
  • 1
    could you post some example data and the expected result? Commented Apr 19, 2014 at 20:12
  • This question will probably help you out, you basically just need 2 joins in your SQL query. Commented Apr 19, 2014 at 20:14
  • this is just the sports notnormalmotorsports.com/NiteKrawler will give you the sports table tell i can get it to display the 3 tables. Commented Apr 19, 2014 at 20:15
  • 1
    You can select any column by using the table.column syntax in your SQL query. Initially, you might just want to use SELECT * ... to see everything. Commented Apr 19, 2014 at 20:41
  • 1
    Possible duplicate of MySQL Multiple Joins in one query? Commented Apr 8, 2018 at 21:57
Related questions
2
Displaying Data From Multiple MySQL Tables
0
MySQL, PHP Inner join and show results in different tables html
2
MYSQL & PHP Display data from multiple tables
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.