phpbar.de logo

Mailinglisten-Archive

[php] SELECT optimieren??? (eventuell OT)

[php] SELECT optimieren??? (eventuell OT)

Boris P boris_(at)_gamate.com
Wed, 7 Mar 2001 11:17:16 +0100


> kann man die noch optimieren?
>
> SELECT artist.id, artist.name, audio.id, audio.user_id, audio.artist_id,
> audio.title, audio.format, audio.genre, audio.year, audio.label,
> audio.length, format.*, genre.* FROM artist, audio, format, genre WHERE
> audio.artist_id = artist.id AND artist.name LIKE '%accessory%' AND
> audio.format = format.id AND audio.genre = genre.id ORDER BY artist.name
> ASC, audio.year DESC

Versuchs mal mit LEFT JOIN (www.mysql.com => documentation)

SELECT * FROM artists LEFT JOIN audio LEFT JOIN format LEFT JOIN genre ON
...

Genaue Syntax erfährst du im Manual unter JOIN



php::bar PHP Wiki   -   Listenarchive