1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[SQL] using two tables in one field on a select in oracle

Discussão em 'Outras Linguagens' iniciado por Stack, Julho 15, 2021.

  1. Stack

    Stack Membro Participativo

    so I came across an issue when creating a view because I need to get values from two tables but use the field (sorry if that's not worded correctly) for example - table1 has legacy users table2 has current users

    and the statement goes like this

    select t1.firstname, t1.lastname from table1 t1;

    is there a way to get first and last names from table two to show in the same result columns as table one? I know I could join the second table in and get the results as another column ex-

    select t1.firstname, t1.lastname, t2.firstname, t2.lastname from table1 t1, table2 t2

    sorry again if what I'm describing is convoluted

    Continue reading...

Compartilhe esta Página