How to joint Two customs Queries with two Joins in only One Query in MySQL

Vote count:

0

The Queries are working perfectly each one separatedly:

SELECT asf.surface_name, am.*
FROM atp_matchs_to_surfaces m2s
LEFT JOIN atp_surfaces asf ON m2s.surfaces_id = asf.surfaces_id
LEFT JOIN atp_matchs am ON am.matchs_id = m2s.matchs_id;

SELECT att.tournament_type, am.*
FROM atp_matchs_to_tournament_type m2s
LEFT JOIN atp_tournament_type att ON m2s.surfaces_id = att.surfaces_id
LEFT JOIN atp_matchs am ON am.matchs_id = m2s.matchs_id;

The tables 'atp_matchs_to_surfaces' and 'atp_matchs_to_tournament_type' are defined in that way:

CREATE TABLE IF NOT EXISTS `atp_matchs_to_tournament_type` (
  `tournament_type_id` int(4) NOT NULL,
  `matchs_id` int(6) NOT NULL,
  PRIMARY KEY (`tournament_type_id`,`matchs_id`)

CREATE TABLE IF NOT EXISTS `atp_matchs_to_surfaces` (
  `surfaces_id` int(4) NOT NULL,
  `matchs_id` int(6) NOT NULL,
  PRIMARY KEY (`surfaces_id`,`matchs_id`)

I want in the same Query all the records of match and surface name+tournament type. It's clear? I hope...

I tried to implement this with SubQueries: http://ift.tt/1DLVYvL and How can an SQL query return data from multiple tables but i can't do it to work.

asked 28 secs ago

bLIGU

6

How to joint Two customs Queries with two Joins in only One Query in MySQL