jonniejoejonson Posted October 23, 2008 Share Posted October 23, 2008 join query Can someone help me with an example of a table join query. i have 2 tables: network_table: 2 fields: networkId : userId images_table: 3 fields imageFilename : imageType : userId I want to select all imageFilenames from images_table that are imageType='photograph' but only from userId's that have a networkId='1' this is a simplified version of what i am trying to do, but if someone could show me how to do this i can try and work the rest out... kind regards J. Quote Link to comment Share on other sites More sharing options...
true2self Posted October 23, 2008 Share Posted October 23, 2008 Can someone shed some light on this one? My question is very similar. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 23, 2008 Share Posted October 23, 2008 Try this: select i.imageFilename from images_table as i inner join network_table as n on ( n.userId = i.userId and n.networkId = 1 ) where i.imageType = 'photograph' Quote Link to comment Share on other sites More sharing options...
jonniejoejonson Posted October 23, 2008 Author Share Posted October 23, 2008 Thanks alot Mr fenway, i will check that out. regards J. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.