Tengo esta consulta que funciona una parte y la otra no, es decir, me trae resultados hasta dpto4p, a partir de ahi, me trae la consulta vacia, por que sera ???
Código SQL:
Ver originalSELECT * FROM `tarifas`
WHERE
`single`<>"--" AND `single`<>""
AND`doble`<>"--" AND `doble`<>""
AND`iva`<>"--" AND `iva`<>""
AND `triple`<>"--" AND `triple`<>""
AND `cuadr`<>"--" AND `cuadr`<>""
AND `dpto2p`<>"--" AND `dpto2p`<>""
AND `dpto3p`<>"--" AND `dpto3p`<>""
AND `dpto4p`<>"--" AND `dpto4p`<>""
AND `dpto5p`<>"--" AND `dpto5p`<>""
AND `dpto6p`<>"--" AND `dpto6p`<>""
AND `dpto7p`<>"--" AND `dpto7p`<>""
AND `dpto8p`<>"--" AND `dpto8p`<>""
AND `suite`<>"--" AND `suite`<>"---"AND `suite`<>"" AND `pecomp`<>"--" AND `pecomp`<>""
AND `mediap`<>"--" AND `mediap`<>""
AND `desayuno`<>"--" AND `desayuno`<>""
AND `almcena`<>"--" AND `almcena`<>""
AND `bcomun1`<>"--" AND `bcomun1`<>""
AND `bcomun2`<>"--" AND `bcomun2`<>""
AND `bcomun3`<>"--" AND `bcomun3`<>""
AND `bcomun4`<>"--" AND `bcomun4`<>""
AND `nr`<>"";