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.




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

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

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.

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