Re: conditional return of data in SELECT
> Everyone lives in a town of some sort (other than some people in northern Maine
Not where some of us live.
> idea is to keep the town name in the "names_and_town" table
> UNLESS that town has a hit in the other table
Not sound, not efficient eg when an individual moves from a town not represented in the other table to a town that is, you need to do two updates.
Subject
Written By
Posted
Re: conditional return of data in SELECT
January 26, 2021 11:20AM
February 01, 2021 05:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.