[PHP-DB] Ignoring specific values in an inner join query?

[André Sannerholt]

Hi everybody.

How to let mysql ignore specific values in an inner join query? In this case
I want it to ignore Null-Values!

$abfrage3=select distinct Anschriften.ID as aid, Anschriften.PLZ as aplz,
Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from Anschriften
inner join Master on Anschriften.ID=Master.A
inner join Master as m on Master.FN=m.FN
inner join Personen on m.NN=Personen.ID
where Personen.Name like '%$name%';

Regards

André



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Ignoring specific values in an inner join query?

[Gary . Every]

$abfrage3=select distinct Anschriften.ID as aid, 
Anschriften.PLZ as aplz,
Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from 
Anschriften
inner join Master on Anschriften.ID=Master.A
inner join Master as m on Master.FN=m.FN
inner join Personen on m.NN=Personen.ID
where Personen.Name like '%$name%'
AND whatever_field_you_want IS NOT NULL
AND whatever_other_field IS NOT NULL;




Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com


 -Original Message-
 From: Andr Sannerholt [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, June 10, 2003 10:42 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] Ignoring specific values in an inner join query?
 
 
 Hi everybody.
 
 How to let mysql ignore specific values in an inner join 
 query? In this case
 I want it to ignore Null-Values!
 
 $abfrage3=select distinct Anschriften.ID as aid, 
 Anschriften.PLZ as aplz,
 Anschriften.STRASSE as astrasse, Anschriften.HNR as ahnr from 
 Anschriften
 inner join Master on Anschriften.ID=Master.A
 inner join Master as m on Master.FN=m.FN
 inner join Personen on m.NN=Personen.ID
 where Personen.Name like '%$name%';
 
 Regards
 
 André
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php