PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Query Question
Query Question
Iniciado por djsummers, 26,sep. 2015 19:50 - No hay respuesta
Publicado el 26,septiembre 2015 - 19:50
Hello All

Is there any way, in the Query editor/builder, to design a query where the results from table (A) are NOT returned is a join is found.

e.g.
table (A) = customers (1 record per customer)
table (B) = customer exclusions (could have 1 or more records per customer / exclusion reason)

I want a query to list all customers that DO NOT have an exclusion

Many thanks

Dave