MySQL Forums
Forum List  »  Newbie

Query question - joins
Posted by: Elizabeth Newman
Date: September 19, 2016 10:13AM

Hello!

This is homework help so please don't give the answers straight out, I REALLY want to learn this! I hope this is a good place to ask this question, I am a MySQL newbie and I really want to learn the syntax!

I am learning joins. Here are my instructions:
FIELDS
From the shippers table: name
From the orders table: order_date, order_num

TABLE
shippers, orders

CONDITIONS
relate the tables on the shipper_id field - use an equality statement to join the tables

I am supposed to save the query as equaljoin which gives me a little help for what to be using but I don't know *how* to use it. Any insight anyone could give me would be greatly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Query question - joins
September 19, 2016 10:13AM
September 19, 2016 10:47AM


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.