Skip to Content
0
Former Member
Feb 20, 2011 at 11:49 AM

Removing a selected field that is specified in the where condition

19 Views

A field that is specified in record selection is getting selected.which i dont want to happen.i tried googling didnt find any possibilities.is there a way to do that?

Example

Record selection:

testDB.testTable.versionID = {?versionID}

SQL Query that is getting generated is as follows

select testDB.testTable.column1,testDB.testTable.versionID from testDB.testTable where testDB.testTable.versionID = {?versionID}

Here i dont want the testDB.testTable.versionID to get selected.since it spoils the distinct record selection.Is there a way to do that?

thanks

Mellison