On Wednesday 22 January 2003 20:28, gordon at hammy dot lonestar dot org
wrote:
> >Description:
>
> The following silly query (silly because it should return no
> records since it is impossible for a.type to have two different
> values simultaneously), returns two records when i
L, R where CONDITION
(2) the rows from L that were not used in (1), with nulls for the R
columns
Then, you can apply an additional WHERE clause to that.
> Date: Wed, 22 Jan 2003 12:28:48 -0600 (CST)
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Left join returns record
x27;d982c79ede90bc888c2ec9757f143e9d','gordonb','2003-01-20
17:12:25',290,'Y');
INSERT INTO dns_rec VALUES
('eb74f350c3ac84314caca073ec778f2a','54','IN',NULL,'A',NULL,'72ccd8a4558c99fa55fca52f96585d51','gor
