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. Link to comment https://forums.phpfreaks.com/topic/129795-join-query/ 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. Link to comment https://forums.phpfreaks.com/topic/129795-join-query/#findComment-672988 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' Link to comment https://forums.phpfreaks.com/topic/129795-join-query/#findComment-673239 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. Link to comment https://forums.phpfreaks.com/topic/129795-join-query/#findComment-673263 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.