consulta mysql

[adrimessi96]

Código SQL:

SELECT codrec, desrec, fentusa, fdevusa
FROM recursos LEFT JOIN usan ON codrec=codrecusa
WHERE (fentusa IS NULL) OR (fdevusa IS NOT NULL);