Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why this SQL Select does not work?
Message
From
11/03/2022 15:00:00
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01683823
Message ID:
01683829
Views:
30
>>Maybe ALL Date_Clos field are NULLs?
>
>I double checked and all but one of the selected records have valid DATE_CLOS. That is, many have NULL and one has a valid date.
>Should I eliminate the NULL dates from the SQL Select?

Yes, from the sub-select NULL is I don't know, so it might be the largest, the lowest, 'cause I don't know.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform