>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
Sir, the SELECT above will work fine. The columns in the WHERE clause
don't have to appear in the SELECT clause.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
