title: (PL/)SQL View over 3 tables, username & password
body: <p>I have 3 tables: personal_trainer, manager and member which all contain some other data and the valuable username, password. </p>
  
  <p>Now the problem is, I want to login with these accounts, I already have a PL/SQL code for the custom authentication. But this is impossible? over 3 tables if I also want to assign a variable to check their priviliges.</p>
  
  <p>I'm already quite far into my application and thus of that I want to create a view that will gather the usernames and passwords from the 3 tables. If possible I'd like to either create a variable within that view, or being able to track out of which table the data is coming.</p>
  
  <p>How would I create this view and how can I get the information?</p>
  
  <p><strong><em>Working with Oracle database</em></strong></p>