Select from two tables ?

Hello! 🙂

I do have two tables.

Table:members
With: id, name, surname, job, company

Table: orders
Witht: id, memberid, subject, region

memberid is connected to Table-members: id

I would like to sort the membertable on "company", my problem is that I also do need the subject, region from the other table.

Thankful for help.

Select company, subject, region
from members, orders
where memberid = members.id
order by company

The following will return all orders ...

SELECT * FROM members, orders
WHERE orders.memberid = members.id
ORDER BY members.company

The following will return a particular order (id=1) ...

SELECT * FROM members, orders
WHERE orders.memberid = members.id
AND orders.id = 1
ORDER BY members.company

The following will return all orders for a particular member (id=1) ...

SELECT * FROM members, orders
WHERE orders.memberid = members.id
AND members.id = 1
ORDER BY members.company

Thanks for the help. 🙂