My Solution And Question With Union
Just come up with this idea to do it. Does anyone have any advises to make it better?\nBy the way, besides using join, does anybody have any idea to do it by us
Just come up with this idea to do it. Does anyone have any advises to make it better?\nBy the way, besides using join, does anybody have any idea to do it by using CASE? \n```\nSELECT per.FirstName, per.LastName, addr.City, addr.State\nFROM Person per, Address addr\nWHERE per.PersonId = addr.PersonId\nUNION\nSELECT per.FirstName, per.LastName, NULL as City, NULL as State\nFROM Person per\nWHERE per.PersonId NOT IN (SELECT PersonId from Address);\n```
[]