How to select second column based on first column from same table

[lln14]

Hi, i wanted to run a query to select second column based on first column from same table..



For example

Column1 Column2
1 a
2 b

Column2 value should be base on Column1 value, that is Column2 value retrive from <table> based on column1 value

[orange]

Not exactly sure what you are asking. Perhaps you could give a little more context.

Is this what you mean??

SELECT column2 
FROM YourTABLE
WHERE column1 = "sometxtValue"