That solution works.  But be cautious when the number of rows in Goods
table or Deliver_types table increases. Probably, after a few rows (may
be about 1,00,000 rows, depending on your Server) the query may become
very sluggish.

So, you could look at some of the solutions suggested on this thread.

However, if you are sure that the number of rows is always very less,
your solution will work without any problem

Ajit


-----Original Message-----
From: Bukovansky@a... [mailto:Bukovansky@a...]
Sent: Friday, August 10, 2001 12:51 PM
To: sql language
Subject: [sql_language] Re: 2 tables join with null values - SOLVED


Sorry, for troubling all, I've searched BOL more, and solved my problem
this way:

SELECT *
	FROM Goods G
	INNER JOIN Delivery_types DT
	ON ISNULL(DT.code_delivery_type, '0') =3D
ISNULL(G.code_delivery_type,
'0')

Once more sorry.

Regards,

Richard Bukovansky