Minus statement in Access

Results 1 to 2 of 2

Thread: Minus statement in Access

  1. #1
    Join Date
    Dec 1969

    Default Minus statement in Access

    Hello Mr. Scott Mitchell, could you say if Access support advance SQL statement as <BR><BR>"SELECT ID FROM Table1 MINUS SELECT ID FROM Table2"<BR><BR>If not, is it any suggestions how I can find another solution.<BR><BR>Thank you in advance, Caterina <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Minus statement in Access

    It does not, minus in an Oracle invention.<BR><BR>select id from table1 where id not in (select id from table2)

Posting Permissions

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