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
Quote Reply
Re: [Ian] 3 way table join. In reply to
I am almost there with this, just need some finishing off type of help. See: http://www.gossamer-threads.com/...i?post=199544#199544.

Thanks.


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] 3 way table join. In reply to
Links SQL questions should probably all go in that forum or the plugins forum otherwise people answering here probably won't know you are referring to links sql specifically.

Last edited by:

Paul: Jun 8, 2002, 1:17 AM
Quote Reply
Re: [Paul] 3 way table join. In reply to
Yes, thanks Paul. I moved it after I realised this last night, and found something related to it in Links too!


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