Home I'm trying to create an sql query using an inner join but I'm getting a syntax error for my first inner join statement

Questions

I'm trying to create an sql query using an inner join but I'm getting a syntax error for my first inner join statement

byMR

April 25, 2022

SELECT u.userId, u.firstName, u.lastName, u.emailAddress, u.phoneNumber, ap.date, ap.time, a.balance 
FROM users u WHERE u.firstName = 'first_name' AND u.lastName = 'last_name' AND u.emailAddress = 'email@gmail.com' 
INNER JOIN accounts a ON u.userId =  a.userId 
INNER JOIN appointments ap ON u.userId = ap.userId;

>Solution :

Your query syntax sequence is wrong. If you want to JOIN any table it should come after your parent table.

SELECT u.userId, u.firstName, u.lastName, u.emailAddress, u.phoneNumber, ap.date, ap.time, a.balance 
FROM users u 
INNER JOIN accounts a ON u.userId = a.userId 
INNER JOIN appointments ap ON u.userId = ap.userId
WHERE u.firstName = 'first_name' AND u.lastName = 'last_name' AND u.emailAddress = 'email@gmail.com';

Check on https://www.w3schools.com/mysql/mysql_join.asp