Demaestro - 2:47 pm on Oct 25, 2011 (gmt 0)
I think this is what you want.
When you use IN, you only want to return 1 column in what is called a Sub-Select
SELECT `Column1`, `Column2`, `Column4` FROM `TableName1` WHERE `Column3` IN (SELECT `Column3` FROM `TableName` WHERE `Column3` = ' + USER_TEXT_HERE + ') ORDER BY `Column1`
Because you want to match Column3 with your IN clause you only want to return Column3 in the sub-select.
Hope this makes sense, post back if you have more questions.