phpbar.de logo

Mailinglisten-Archive

Can & can't
Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Can & can't



You can do:
select d.nr from  
                 mdps_doctag as t5, 
                 mdps_doctag as t6, 
                 mdps_doc as d 
where    d.nr=t5.docnr and (t5.tagnr=98  and t5.inhalt like "%5%") 
 and t5.docnr=t6.docnr and (t6.tagnr=101 and t6.inhalt like "%Natur%") 
group by d.nr 
;
--------------------
You can't do:
select d.nr from 
                 mdps_doctag as t1, 
                 mdps_doctag as t2, 
                 mdps_doctag as t3, 
                 mdps_doctag as t4, 
                 mdps_doctag as t5, 
                 mdps_doctag as t6, 
                 mdps_doc as d 
where    
(        d.nr=t1.docnr and (t1.tagnr=102 and t1.inhalt like "Empfehlungen")  
 and t1.docnr=t2.docnr and (t2.tagnr=100 and t2.inhalt like "deutsch") 
 and t1.docnr=t3.docnr and (t3.tagnr=104 and t3.inhalt like "Profile 1") 
 and t1.docnr=t4.docnr and (t4.tagnr=103 and t4.inhalt like "subject%") 
) or
(        d.nr=t5.docnr and (t5.tagnr=98  and t5.inhalt like "%5%") 
 and t5.docnr=t6.docnr and (t6.tagnr=101 and t6.inhalt like "%Natur%") 
)
group by d.nr 
;
--------------------
Tell me why!

P. Bierans
--
Patrick Bierans / LYNET Kommunikation / pbierans_(at)_lynet.de
-----------------------------------------------------------------------
Das Internet-Systemhaus fuer Multimedia- und Netzwerkloesungen 
 Zentrale: St.-Juergen-Ring 66, 23564 Luebeck, 
 Tel: +49-451-6131-0, Fax: -333 
 Niederlassung: Wendenstr. 379, 20537 Hamburg, 
 Tel: +49-40-65738-0, Fax: -333

---
*** Abmelden von dieser Mailingliste funktioniert per E-Mail
*** an mysql-de-request_(at)_lists.4t2.com mit Betreff/Subject: unsubscribe


Home | Main Index | Thread Index

php::bar PHP Wiki   -   Listenarchive