I am trying to build a query to
1) Get all the results from one table, 'images'
2) For each entry in the 'images' table, find the correct title from
the 'playlist' OR 'media' table where images.id = which_table.images_id
images table
id, filename
playlist table
title images_id
media table
title, images_id
So the result would something like
id filename title
1 file1 playlist-title1 // id matches entry in
the Playlist table
2 file2 playlist-title2
3 file3 media-title1 //id matches entry in the
Media table
4 file4 media-title2
any help is appreciated as my queries have been pretty simple up to
this point
many thanks
g
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
