Re: [PHPwestoz] [OT] Relational SQL Databases

[Nicolas Connault <nicou@sweetpeadesigns.com.au>]

Nicolas Connault wrote:

> SELECT Songs.*, Albums.* FROM Songs, Albums, Artists
> WHERE Artists.ID = Songs.ArtistID
> AND Album.ID = Songs.AlbumID
> AND Artist.Artist = "Avril"

Sorry I made a mistake, let me correct it here:

SELECT Songs.*, Albums.* FROM Songs, Albums, Artists
WHERE Artists.ID = Albums.ArtistID
AND Album.ID = Songs.AlbumID
AND Artist.Artist = "Avril"

Nicolas