SQL selecting from two linked tables

Question

I have two tables in MySQL, customer and contacts

each row in customer can have multiple rows in contacts and contacts.company will equal customer.sequence

how can i run a query to search both tables and return the results from the customer table only?

for example, if i have this data:

customer:

sequence = 123
company = Company A

sequence = 321
company = Company B

contacts:

company = 123
forename = John

company = 123
forename = Steve

company = 321
forename = Joe

company = 321
forename = Andy

company = 321
forename = John

and i search for Andy - it should return Company A

If i search for John, it should return Company A and Company B

Your question is not clear enough. What are you searching both tables for if you only want results from the customer table? SELECT * FROM CUSTOMER; will do that without searching both tables. — kojow7, Jun 01 '15 at 22:28
possible duplicate of [How to join two tables mysql?](http://stackoverflow.com/questions/3536283/how-to-join-two-tables-mysql) — Andy Hoffner, Jun 01 '15 at 22:29

score 0 · Answer 1 · answered Jun 01 '15 at 23:15

0

select
    C.Company
from
    Customer,
    Contacts
where
    Customer.Sequence = Contacts.Company
    and Contacts.Forename = '<your search name goes here>'

answered Jun 01 '15 at 23:15

Rui Miguel Pinheiro

112
8

SQL selecting from two linked tables

1 Answers1