Inner Join Issue


doing the class and it is giving me an error “Error: near line 1: near “select”: syntax error”. can’t figure out what the error is. here is the code

select * from orders
join subscriptions
on orders.subscription_id=customers.subscription_id
select * where description=‘Fashion Magazine’;


Please remember to include a link to the exercise when posting a new topic relating to lessons.


On the 4th line in your post you don’t need the second ‘Select *’ just the WHERE clause.


Why did you put a SELECT * before the where? It does not make sense. Please try removing it so the query should look like this

SELECT * from orders
JOIN subscriptions
ON order.subscription_id = customers.subscription_id
WHERE description = 'Fashion Magazine';


Discard SELECT from the 4th line