Simple problem here. I am not an SQL wizard, I have 2 tables:
Cities
Cno City
1 Boston
2 Chicago
3 Seattle
Friends
Fno Name Cno
1 Charlie Jones 1
2 Sam Smith 1
3 Cheryl Clancy 3
I wish to create a view which shows:
Fno Name City
1 Charlie Jones Boston
2 Sam Smith Boston
3 Cheryl Clancy Seattle
In other words, takes Friends table and converts Cno to City in the view. Maybe an inner join but not savvy in SQL.
Thanks in advance.