Multiple select in sql

Question

I'm doing a database about attractions in a certain state, and I have these tables:

The first table is for the cities in a state

The other table is for wineries in those cities

I'm having trouble printing the wineries and cities name together, any suggestions?

Please read meta.stackoverflow.com/questions/285551/… and the accepted answer — user330315
– user330315, Commented Apr 28, 2017 at 7:21

sovas · Accepted Answer · 2017-04-28 06:38:45Z

3

You can use join keyword to join two tables, for example:

select w.winery_Name, c.city_Name from Wineries w
inner join Cities c on w.city_ID = c.cities_ID;

answered Apr 28, 2017 at 6:38

sovas

1,5781 gold badge11 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Glad to help you, feel free to accept my answer :) thanks

Could please explain why you used w and c here "w.winery_Name, c.city_Name"

To get object reference. So 'w' is Wineries instance with winery_Name field inside.