How to join two tables using mysql

Question

It's been so long since I did any Mysql queries I forgot how to do basic joins. I have two tables:

Orders_ and Members

I need to create one view which displays all the orders with the associated Email and Member_Id.

Do some research first. – Sasanka Panguluri Aug 08 '13 at 19:51 — Sasanka Panguluri, Aug 08 '13 at 19:51

score 2 · Answer 1 · answered Aug 08 '13 at 19:51

2

The query, based on your image, should look like so:

SELECT Orders.*, Members.* 
    FROM Orders 
    INNER JOIN Members ON Orders.coordinateList_Id = Members.Members_Member`

answered Aug 08 '13 at 19:51

random_user_name

score 1 · Accepted Answer · answered Aug 08 '13 at 19:52

1

I would refer to the MySQL reference

SELECT * 
    FROM Orders 
    INNER JOIN Members
        ON Orders.coordinateList_Id = Members.Members_Member

answered Aug 08 '13 at 19:52

Malkus

2 Answers2