Simple? SQL Question

Results 1 to 2 of 2

Thread: Simple? SQL Question

  1. #1
    Join Date
    Dec 1969

    Default Simple? SQL Question

    Select * will grab all the fields<BR><BR>Select field19, field20 will grab 2 of the fields<BR><BR>Is there a way to write the statement where I can grab everything but 2 fields, as opposed to explicitly specifying the other eighteen?<BR><BR>Ex: Select (* exclude field19, field20) <BR>(I&#039;m sure that syntax doesn&#039;t work!!)

  2. #2
    Join Date
    Dec 1969

    Default No.

    No you must name all columns you wish to retrieve.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts