nicht angemeldet
Oh Gott, da hab ich ja gestern das Schreiben komplett verlernt.
Das eigentliche Problem hab ich gelöst:
SELECT tara_mains.ID,tara_alts.ID,tara_alts.NAME,tara_mains.POINTS,tara_mains.JOINS,tara_mains.LEADS,(SELECT tara_alts.NAMEFROMtara_alts,tara_mainsWHEREtara_alts.ID=tara_mains.AID) FROM tara_mainsJOINtara_altsONtara_mains.ID=tara_alts.MIDANDtara_alts.MID= (SELECTtara_alts.MIDFROMtara_altsWHEREtara_alts.NAME='heinrich')
Hab aber auch schon ein neues Problem:
DELETE tara_alts,tara_mainsFROMtara_alts,tara_mainsWHEREtara_alts.MID= (SELECTtara_alts.MIDFROMtara_altsWHEREtara_alts.NAME= 'heinrich') ANDtara_mains.ID= (SELECTtara_alts.MIDFROMtara_altsWHEREtara_alts.NAME = 'heinrich')
Ich versteh nicht genau, was an diesem Statement falsch ist.
#1093 - You can't specify target table 'tara_alts' for update in FROM clause
Sagt mir phpMyAdmin/MySQL.
MfG
bubble