Join two select, what should I do?

Question

Join two select, what should I do?

Navigation

#1 by (0 votes)

0

How to merge these two SELECTS?

SELECT *
FROM doacao d
LEFT JOIN foto f ON (d.iddoacao = f.iddoacao)
WHERE (d.idbeneficiario IS NULL);

SELECT email
FROM doador dd
INNER JOIN doacao d ON (dd.iddoador = d.iddoador)
WHERE (dd.iddoador IS NOT NULL)
  AND (d.idbeneficiario IS NULL);

mysql

asked by anonymous 30.06.2016 / 00:53

1 answer

How to mount a select from DB Uploading images by increasing the file size by almost 10x

score 0 · Answer 1

Try this:

SELECT email, d.*
FROM doador dd
INNER JOIN doacao d ON (dd.iddoador = d.iddoador),
LEFT JOIN foto f ON (d.iddoacao = f.iddoacao)
WHERE (dd.iddoador IS NOT NULL)
      AND (d.idbeneficiario IS NULL);