Inner Join Issue


#1

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’;


#2

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


#3

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