SQL select statements with multiple tables

Question

Given the following two tables   Person table  id  pk   first  middle  last  age  Address table  id pk   person id  fk person id   street  city  state  zip   How do I create an SQL statement that returns all information for people with zip code 97229

User · Answer

You need to join the two tables   select p id  p first  p middle  p last  p age         a id as address id  a street  a city  a state  a zip from Person p inner join Address a on p id   a person id where a zip    97229     This will select all of the columns from both tables   You could of course limit that by choosing different columns in the select clause

User · Answer

Select   from people p  address a where  p id   a person id and a zip  97229     Or you must TRY using JOIN which is a more efficient and better way to do this as Gordon Linoff in the comments below also says that you need to learn this   SELECT p    a street  a city FROM persons AS p JOIN address AS a ON p id   a person id WHERE a zip    97299     Here  p   means it will show all the columns of PERSONS table

User · Answer

Like that     SELECT p    a street  a city FROM persons AS p JOIN address AS a ON p id   a person id WHERE a zip    97299

User · Answer

select P    A Street  A City  A State from Preson P inner join Address A on P id A Person id where A Zip 97229 Order by A Street A City A State

User · Answer

First select all record from person table  then join all these record with another table  Address    now u have record of all the persons who have their address in address table   so finally filter your record by zipcode    select   from Person as P inner join Address as A on      P id   A person id Where A zip  97229

[sql] SQL select statements with multiple tables

Examples related to sql