If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Joins on NULL Date values
I have some queries whereby I need to join two tables based on two date
fields that are in both queries. Sometimes date 1 or date 2 will have NULL values, but I still need to perform the join accurately which doesn't work. I cannot amend the values in the table to a default date (#01/01/1000#) as it comes from a SQL process that cannot be ammended. Any thoughts? 1:1 join. Ta |
Thread Tools | |
Display Modes | |
|
|