Ignoring specific values in an inner join query?
| From: | Andr� Sannerholt | Date: | Tue, 10 Jun 2003 15:42:18 +0000 |
| Subject: | Ignoring specific values in an inner join query? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28490@lists.php.net to get a copy of this message | ||
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é