how to group two columns in one

i have three tables

customer, people, companies

tables people and companies have a "customerID"

table people have "cpf" and table companies have "cnpj"

i need to query

customerID, (cpf OR cnpj)

https://stackoverflow.com/questions/66082723/how-to-group-two-columns-in-one February 07, 2021 at 06:41AM