Gossamer Forum
Quote Reply
3 way table join.
Calling MySQL experts!

I have what seems to be a 3 way table join problem, I need a hand with.

Table: Table A ............Table B ............Table C
Col1:___ID <-related->CatID LinkID<-related-> ID
Col2:___FCType

I want to select all the ID's in Table C which have a corresponding FCType = 'something' in table A.

Not a beginers join by any means. I can think of some inefficent ways of doing this, but this involves creating another table to store results midway... yuk!

Any help is much appreciated.

Smile


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Jun 7, 2002, 8:41 PM
Subject Author Views Date
Thread 3 way table join. Ian 2050 Jun 7, 2002, 8:37 PM
Thread Re: [Ian] 3 way table join.
Ian 1943 Jun 7, 2002, 9:54 PM
Thread Re: [Ian] 3 way table join.
Paul 1934 Jun 8, 2002, 1:17 AM
Post Re: [Paul] 3 way table join.
Ian 1919 Jun 8, 2002, 8:46 AM