Solved it with Union :)
SELECT images.id,images.name, playlist.title FROM images,playlist
WHERE playlist.image_id = images.id
UNION
SELECT images.id,images.name, media.title FROM images,media WHERE
media.image_id = images.id
ORDER BY id ASC
On Jun 23, 2006, at 6:44 PM, Graham Anderson wro
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
t
m: Rob Brooks [mailto:[EMAIL PROTECTED]
> Sent: 29 March 2005 15:57
> To: 'MySQL list'
> Subject: table join question
>
> Although I didn't find it in the docs anywhere, I know from experience
> that
> you cannot join more than 31 tables in 4.0.21
>
>
&g
Although I didn't find it in the docs anywhere, I know from experience that
you cannot join more than 31 tables in 4.0.21
I was wondering if anybody knew if this limit has changed in version 5
Thx
Rob
show us your table structure
show us your table values
-Original Message-
From: Barry J. Wiegan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:00 AM
To: [EMAIL PROTECTED]
Subject: Table join question
Hi,
I'm trying to build a query to solve a fairly simple probl
Hi,
I'm trying to build a query to solve a fairly simple problem.
I have two tables (A and B) linked by a common ID. I want to
locate a specific record in A that is linked to two or more
records in B based on second field in B matching certain criteria.
I've tried every type of inner, outer, left
On Tuesday 05 February 2002 9:59 am, Barry J. Wiegan wrote:
> Hi,
>
> I'm trying to build a query to solve a fairly simple problem.
> I have two tables (A and B) linked by a common ID. I want to
> locate a specific record in A that is linked to two or more
> records in B based on second field in B
Hi,
I'm trying to build a query to solve a fairly simple problem.
I have two tables (A and B) linked by a common ID. I want to
locate a specific record in A that is linked to two or more
records in B based on second field in B matching certain criteria.
I've tried every type of inner, outer, left