need help with SQL quries?

Question

following is question:

two tables (1) Address table and (2) city table,

How do I select address table and city table where city is 5 (las vegas).

Please help with query

Answer 1

SELECT * FROM Address INNER JOIN City

ON Address.CityID = City.CityID

WHERE CityID = 5



I suggest you do some reading with the JOIN parameter (INNER JOIN, LEFT JOIN...), it'll answer a lot of your future questions.



G'luck.

Answer 2

While I can add little to the previous comments about joining the two tables, I can't help wondering why have two tables at all? There is such a thing as taking normalization to extremes and the added overhead of additional tables and more joins increasing query complexity makes this a dubious choice for a separate table.

Answer 3

first crate a view "AddressCity" with the condition:



Address.CityCode = City. CityCode

(can be done by dragging the text of CityCode from one table to the corresponding on the other table in the view editor panel)



Then run this query



SELECT * from AddressCity

Where CityCode = 5

Answer 4

SELECT *



FROM Address left outer join City on Address.CityID = City.CityID



WHERE CityID = 5

Answer 5

Use The Inner Join

Answer 6

I would add a caution here that, depending on field definitions, you may need quotes around your parameter value.



ie:

SELECT * from AddressCity

Where CityCode = '5'