SELECT
a.Cedula
FROM
xls_db.dpersonales a
left join
aldea.participantes b ON a.cedula = b.cedula
cabe destacar que son tablas de bd diferentes, gracias de antemano......
Posted 13 October 2013 - 10:37 AM
SELECT
a.Cedula
FROM
xls_db.dpersonales a
left join
aldea.participantes b ON a.cedula = b.cedula
Posted 13 October 2013 - 01:36 PM
SELECT
a.Cedula
FROM
xls_db.dpersonales a
left join
aldea.participantes b ON a.cedula = b.cedula
where b.cedula is null
Posted 13 October 2013 - 02:01 PM
SELECT
a.Cedula, b.cedula
FROM
xls_db.dpersonales a
LEFT JOIN
aldea.participantes b ON a.cedula = b.cedula
WHERE b.cedula IS NULL