Douglas Sims wrote:
Giulio wrote:
HI all,
I have two tables, let's say AudioTrack and Category
Every AudioTrack record can belong to one or more ( or none ) Categories.
I have created an intermediate table, AudioTracks_Categories
containing only the IDs of AudioTrack and Category to keep track
Il giorno 04/gen/04, alle 17:34, Douglas Sims ha scritto:
Hi Giulio
Hi Doug,
I think you could do this by repeatedly left-joining the categories
table as in this:
SELECT AudioTrack.*
FROM AudioTrack A
LEFT JOIN AudioTracks_Categories C1 ON A.AudioTrack_id=C1.AudioTrack_id
LEFT JOIN AudioTracks
Hi Giulio
I think you could do this by repeatedly left-joining the categories
table as in this:
SELECT AudioTrack.*
FROM AudioTrack A
LEFT JOIN AudioTracks_Categories C1 ON A.AudioTrack_id=C1.AudioTrack_id
LEFT JOIN AudioTracks_Categories C2 ON A.AudioTrack_id=C2.AudioTrack_id
LEFT JOIN AudioTra
HI all,
I have two tables, let's say AudioTrack and Category
Every AudioTrack record can belong to one or more ( or none )
Categories.
I have created an intermediate table, AudioTracks_ Categories
containing only the IDs of AudioTrack and Category to keep track of the
link.
I can easily find A
