Hi Josh,
One more question regarding this. When I try to put an 'OR' clause for my view in the view designer, it puts for the whole table.
ie
SELECT *;
FROM STARS.REQUEST Request;
WHERE a = ?valuea;
AND b = ?valueb;
AND c = ?valuec
OR c is null;
I want it to be
SELECT *;
FROM STARS.REQUEST Request;
WHERE a = ?valuea;
AND b = ?valueb;
AND (c = ?valuec or c is null);
How can I create the view like this in the view designer?. I know that you can get around this problem by creating the view programmatically.
Thank You
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement