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
You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or
the reverse if Table2 always has a date. -- Build a little, test a little. "Andy" wrote: I am trying to avoid this solution as my tables are VERY large and it says that it is not very efficient. http://bytes.com/topic/access/answer...ll-value-fails "Andy" wrote: 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 | |
|
|