SQL SQL Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners. here is what i have so far but says query completed but nothing showsSELECT O.FIRST_NAME, O.LAST_NAME,P.ADDRESS FROM OWNER AS O,PROPERTY AS P two tables im grabbing the information from are attached owner table and property expected outcomeFIRST_NAMELAST_NAMEADDRESSErnestBurke30 West Thomas Rd.CeydaAksoy782 Queen Ln.NicoleBianchi9800 Sunbeam Ave.JakubKowalczyk105 North Illinois Rd.HaydonSims887 Vine Rd.Elle-MayMoore8 Laurel Dr.MeerabCole447 Goldfield St.JakubKowalczyk594 Leatherwood Dr.MakeshPatel504 Windsor Ave.JanineLopez891 Alton Dr.AmmarahJones9531 Sherwood Rd.SethRedman2 Bow Ridge Ave.HaydonSims916 Kent Drive OWNER_NUMLAST_NAMEFIRST_NAMEADDRESSCITYSTATEZIP_CODEAK102AksoyCeyda411 Griffin Rd.SeattleWA98131BI109BianchiNicole7990 Willow Dr.New YorkNY10005BU106BurkeErnest613 Old Pleasant St.Twin FallsID83303CO103ColeMeerab9486 Circle Ave.OlympiaWA98506J0110JonesAmmarah730 Military Ave.SeattleWA98126К0104KowalczykJakub7431 S. Bishop St.BellinghamWA98226LO108LopezJanine9856 Pumpkin Hill Ln.EverettWA98213MO100МooreElle-May8006 W. Newport Ave.RenoNV89508 PROPERTY_IDOFFICE_NUMADDRESSSQR_FTBDRMSFLOORSMONTHLY_RENTOWNER_NUM1130 West Thomas Rd.16001NULLBU10621782 Queen Ln.210042NULLAK10219800 Sunbeam Ave.100521NULLBI10941105 North Illinois Rd.17501NULLKO1041887 Vine Rd.112521NULLSI10518 Laurel Dr.212542NULLMO10072447 Goldfield St.16752NULLCO1038594 Leatherwood Dr.27005NULLК0104

Use NATURAL JOIN operator since both have common attribute Owner_Num

Answered: Management team with a list of all…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

SQL

Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners.

here is what i have so far but says query completed but nothing shows

SELECT O.FIRST_NAME, O.LAST_NAME,P.ADDRESS

FROM OWNER AS O,PROPERTY AS P

two tables im grabbing the information from are attached owner table and property

expected outcome