They both allow sql and one needs two columns and another needs one column as a result. What is the essential difference?
Edited on 20th Nov 2018.
As I may not have posed the query completely, which I feel after reading responses , let me give you what is my set up.
The select list is querying what is called as work status and sql looks like this.
Select meaning ,lookupcode from lookups
Where lookuptype='workstatus'
Should I use source now? Giving the same query in source makes any difference?If yes which way? If not what is it used for?