- Using Inner Join When The Field In My Data Table Has The Null Default Value:

I have a datatable : Data_Table
  and a look up table: Lk_table. Myfield that I
use in Inner Join
  is defined in both the
data and look table.

 

So I build my query like this:

SELECT
     * FROM
         dbo. Data_Table
  INNER JOIN


                     
dbo. Lk_table ON dbo.Data_Table.MyField = dbo.Lk_table.Myfield


                

The pb, sometimes
 I
have myfield still with its default null value in the datatable: Data_Table.
So, I end up getting 0 record when I execute the query shown above.

How do I turn that around so that even if myfield in Data_Table
is Null, I still get the records from Data_Table. (I don t want a set of
records including all possible values from the look up table: Lk_Table)