+ Reply to Thread
Results 1 to 2 of 2

Thread: Select all fields and exclude 2 fields

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    11

    Select all fields and exclude 2 fields

    I want to select all fields on a table and exclude two fields .
    I know that i can use select * from tbl_name , but is there another way ?

  2. #2
    No it can`t be , you can either select all or only specify all fields except the two you don`t want .
    For example if your table : Table contains 4 fields : Field1 , Field2 , Field3 and Field4 , and you want to exclude Field3 and Field4 then you will need to do that :
    Code:
    Select Field1,Field2 From Table

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

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