Home / Questions / 360233
Accepted
Fernando Iam
Asked: 2020-05-29 10:42:21 +0800 CST 2020-05-29 10:42:21 +0800 CST

Get 2 data from two different tables

  • 772

I want to get all the emails from a table usuarios, and only one email from the table empresa.

I have this to get the emails from a table, but how can I add another one SELECTso that they come out together? and then be able to use this data. I had thought something like that, but I'm not sure I'm doing it right

SELECT usuario.email FROM usuario 
WHERE usuario.tipo_usuario='usuario' AND usuario.bolsa_ofertas='activado' 
(SELECT empresa.email FROM empresa WHERE empresa='ejemplo');
sql

2 Answers

  1. Best Answer

    I don't know if the following query will be useful to you:

    SELECT usuario.email, empresa.email FROM usuario 
    JOIN empresa 
    WHERE usuario.tipo_usuario = 'usuario' 
    AND empresa.empresa = 'ejemplo' 
    AND usuario.bolsa_ofertas = 'activado'
    • 1

  2. Since I don't know the related fields of the user and company tables, I'll give you an example of how it could be if it works for you:

    SELECT u.user.email, e.company.email from user u, company e where e.cod.company=u.cod.user

    • 0