Information générale
Catégorie:
Codage, syntaxe et commandes
Did you try to switch the SELECTs?
Vlad
>I have a SQL statement with two selects UNIONed together. Both halfs use outer joins.
>
>In the first half, "MyField" gets ALL numeric values as it should. In the scond half, however, "MyField" must somtimes (correctly) get .null. values. Problem? The first half of the union seems to be setting up "MyField" as a "NOT NULL" field and when the second half tries to add null values, I get an error that "MyField does not accept null values."
>
>How can I tell "MyField" to accept NULL values in the first half of the union?
>
>(BTW - reversing the selects won't work because another field - "Myfield2" works just opposite,)
>
>TIA!
>Ken
Précédent
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