Query in 2 tables - JOIN

Question

I am struggling in MySQL. I have 2 Tables, one Table with all the data and 1 table with generic information about a node.

dataTable

ID
Name

nodeTable

ID
Address

Now I have the Address and I want to build a query in which the Name is returned. I probably should use a JOIN but the last time I worked with MySQL goes way back.

Thanks in advance

Please share some sample data and the result you're trying to get for it — Mureinik, Oct 22 '17 at 18:58

score 2 · Answer 1 · answered Oct 22 '17 at 18:59

2

select
    dataTable.name
from
    dataTable
    inner join nodeTable on
        dataTable.ID = nodeTable.ID   
where
    nodeTable.adress = 'your address'

answered Oct 22 '17 at 18:59

Indent

4,583
1
15
31

1

Thanks a lot. I need to play more often with mysql :-) – Jeroen Oct 22 '17 at 19:24

score 0 · Answer 2 · answered Oct 22 '17 at 18:59

0

Does the below code fulfill your needs?

select Name 
  from dataTable, nodeTable 
 where dataTable.ID = nodeTable.ID
   and Address = 'Rathausstrasse'

answered Oct 22 '17 at 18:59

inxoy

3,444
2
12
21

Don't encourage a old JOIN style that is over 25 years old use proper INNER JOIN syntax – Raymond Nijland Oct 22 '17 at 19:15
its just the style - it doesn't make a difference performance wise - the query optimizer is smart enough nowadays... – inxoy Oct 22 '17 at 19:17
the newer INNER JOIN syntax is easier to read and understand,, performance wise indeed makes no difference – Raymond Nijland Oct 22 '17 at 19:22

score 0 · Answer 3 · answered Oct 22 '17 at 19:00

0

select d.name
from dataTable d, nodeTable n
on d.id = n.id
where n.address = '10 Main St.';

answered Oct 22 '17 at 19:00

J_H

10,963
1
18
34

Don't encourage a old JOIN style that is over 25 years old use proper INNER JOIN syntax – Raymond Nijland Oct 22 '17 at 19:15

Query in 2 tables - JOIN

3 Answers3