Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT datos.* FROM
- (SELECT cuenta,clave_referencia,clave,bloqueo FROM tbl_deudas_clientes WHERE cuenta=757172 AND clave2=9999 GROUP BY bloqueo,cuenta order by cuenta) datos
- LEFT join
- (SELECT cuenta, bloqueo FROM tbl_deudas_clientes WHERE cuenta=757172 AND clave2=9999 AND bloqueo = 'H' GROUP BY cuenta, bloqueo order by cuenta) filtro
- ON datos.cuenta = filtro.cuenta
- WHERE filtro.cuenta IS null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement