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

Re: [PHPwestoz] [OT] Relational SQL Databases

To: phpwestoz@lists.linux.org.au
Subject: Re: [PHPwestoz] [OT] Relational SQL Databases
From: Nicolas Connault <nicou@sweetpeadesigns.com.au>
Date: Tue Feb 22 16:09:01 2005
In-reply-to: <421AE7DB.4010204@sweetpeadesigns.com.au>
List-archive: <http://lists.linux.org.au/archives/phpwestoz/>
List-help: <mailto:phpwestoz-request@lists.linux.org.au?subject=help>
List-id: PHP users in Western Australia (or nearby) <phpwestoz.lists.linux.org.au>
List-post: <mailto:phpwestoz@lists.linux.org.au>
List-subscribe: <http://lists.linux.org.au/listinfo/phpwestoz>, <mailto:phpwestoz-request@lists.linux.org.au?subject=subscribe>
List-unsubscribe: <http://lists.linux.org.au/listinfo/phpwestoz>, <mailto:phpwestoz-request@lists.linux.org.au?subject=unsubscribe>
Organization: SweetPea Designs
References: <421AE21E.6010502@tigris.org> <421AE7DB.4010204@sweetpeadesigns.com.au>
Reply-to: phpwestoz@lists.linux.org.au
Sender: phpwestoz-admin@lists.linux.org.au
User-agent: Mozilla Thunderbird 1.0 (Windows/20041206)

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

References:
- [PHPwestoz] [OT] Relational SQL Databases
  - From: Timothy White <weirdo@tigris.org>
- Re: [PHPwestoz] [OT] Relational SQL Databases
  - From: Nicolas Connault <nicou@sweetpeadesigns.com.au>

Prev by Date: Re: [PHPwestoz] [OT] Relational SQL Databases
Next by Date: Re: [PHPwestoz] [OT] Relational SQL Databases
Previous by thread: Re: [PHPwestoz] [OT] Relational SQL Databases
Next by thread: Re: [PHPwestoz] [OT] Relational SQL Databases
Index(es):
- Date
- Thread