The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

can't determine proper JOIN query construct

Hello, I have a newbie question: Running Mariadb 10.4, I'm using a baseball database containing 22 tables. All of the tables have a column named 'playerID'. What I'm trying to do is return results from two tables ('Batting' and 'Fielding') for a specific playerID (i.e. show the results for a specific playerID from both tables in one table) using a JOIN query. There are plenty of generic solutions on the net, but I have yet to find one that explains exactly what each segment of this query means. I thought this query would work, but apparently there's a syntax error:

select playerID from Batting, inner join Fielding on Batting.playerID = Fielding.playerID;

TIA for any help provided.

Regards,

Steve Silvi

Answer Answered by Ian Gilfillan in this comment.

The syntax error probably points you to the part of the query with the mistake. In this case, you have a comma after from Batting which shouldn't be there. See Joining Tables with JOIN Clauses for more examples.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.