mysqlsqldatabasejoinsubquery
SQL query join or subquery
[
][2]][2]I have 2 tables
[2]: https://i.sstatic.net/7v4nT.png**strong text**
I need data from these 2 tables in such a ways that a new table is formed with the following data
mid, result, date, team1id, team2id from matches table on the basis of tourid=6 and from table of team i need to show the Tname as team1 and Tname as team2.
Solution
Sounds like you need a join:
select matches.*,t1.Tname as team1,t2.Tname as team2 from matches
join team t1 on t1.Teamid=matches.team1id
join team t2 on t2.Teamid=matches.team2id
where tourid=6
- How do I set the default schema for a user in MySQL?
- How to output geoJSON file from mysql spatial table?
- PHPMyAdmin Configuration not working because of MySQL user password?
- The best way of storing many to many hierarchical data in sql
- JDBC connection without database definition
- Can Magento Connect to Another MySQL database?
- PHP isset() with multiple parameters
- bootstrap table doesnot display data
- CakePHP-2.0: Refactor my code editing faster sql query, need a faster sql query
- ERROR 2006 (HY000): MySQL server has gone away
- Problems selecting multiple column
- Order rows based on another table?
- MySQL Workbench edit data
- brew start and brew restart wont start service
- Sort MySQL query result by calculated average DESC
- PHP MYSQL Array and sort
- Use queryset result as a parameter to a raw SQL in Django
- Getting multiple values for a date for Google Charts
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it