General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only