Kenneth Priisholm
|
Posted: 04/23/2001, 9:31 AM |
|
Hi.
I'm trying to create a 'Grid-and-Record'-routine from an existing MSSQL-DB,
with a join between tbl1 and tbl2, allowing the foreign-key from tbl2 to
have a <NULL>-value in tbl1 - as a "not specified"-value, so to speak.
Problem is, that when using the options in the 'JOIN'-tab, only records with
a 'NOT-NULL'-foreign-key are returned in the GRID-view; there must be a
simple work-around to generate SQL that allows records to make a join with a
NULL-value in an fk-field...BUT HOW?
Thank You,
//Kenneth.
|
|
|
|