MySQL Forums
Forum List  »  Newbie

Re: Replacing things in relational database - JOIN, maybe?
Posted by: Paul Roper
Date: April 21, 2015 08:32AM

OK - I'm getting there. I've managed to SELECT all the required data; I just need to replace it now. This is what I made:

SELECT tickets.ticket_price, events.event_name
FROM tickets JOIN events ON tickets.event_id = events.event_id
WHERE events.event_name = 'New York'

Options: ReplyQuote


Subject
Written By
Posted
Re: Replacing things in relational database - JOIN, maybe?
April 21, 2015 08:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.