Re: Hiding data after select

>Hi there, > >suppose I have table table1 with columns col1,col2,col3,col4 >I would like to set up a query that omits eg. col1 from the output even >though col1 must satisfy some condition: > >SELECT col2,col3,col4 from table where col1=condition > >Any suggestions ? > >Thanks in advance > >A.Hann

Hiding data after select

Hi there, suppose I have table table1 with columns col1,col2,col3,col4 I would like to set up a query that omits eg. col1 from the output even though col1 must satisfy some condition: SELECT col2,col3,col4 from table where col1=condition Any suggestions ? Thanks in advance A.Hannemann -