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.
http://www.iuni.com/...tware/web/index.html
Links Plugins
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
3 way table join.