Inner Join of Queries

Navigation
1

I comment, I have a query that has a query that brings me certain users under certain conditions, and I have another query with other idusuarios submitted to other conditions, so I would have 

CONSULTA 1: XXX idusuarios
CONSULTA 2: XXX idusuarios

My question is: Is there a way to do a INNER JOIN of those queries, bringing only where the idusuarios match?

    
asked by JuanManuel245 03.09.2018 в 21:43
source

1 answer

2

maybe something like this can help you: 

select
    *
from
    schema.table1 a
    inner join schema.table2 b on (a.id_usuario=b.id_usuario)
    
answered by 03.09.2018 / 22:20
source
java properties / xml as constant I can not modify table record using EF