PL/SQL check if a row of table A exists in tables B or C

Vote count:

0

The following tables names are just an example...

Imagine that I have a table USER, a table SUB_USER_1 and a table SUB_USER_2. The tables SUB_USER_1(2) have a column ID and a column USER_ID, that connects them to the USERS table.

Now if I wanted to know if a user is of type 1 or 2, checking if it exists in table SUB_USER_1 or SUB_USER_2, what was the best way to do it?

Thanks in advance.

asked 1 min ago

chester

31

PL/SQL check if a row of table A exists in tables B or C