Professional Web Applications Themes

How to select record on one table but not the other - Coldfusion Database Access

Hi, I have two tables that share a userid in common. I want to select record from table1 that are not on table2 and each record on table1 should only be returned once. What would be the select query to achieve this with MS Access 2003? thanks...

  1. #1

    Default How to select record on one table but not the other

    Hi,

    I have two tables that share a userid in common. I want to select record from
    table1 that are not on table2 and each record on table1 should only be returned
    once.

    What would be the select query to achieve this with MS Access 2003?

    thanks

    Rustywater Guest

  2. #2

    Default Re: How to select record on one table but not the other

    select distinct some fields
    from some tables including table1
    where some conditions are met
    and table1.userid not in
    (select userid from table2)
    Dan Bracuk Guest

Similar Threads

  1. How can i retrieve record ONLY From 300 - 400 in amillion Record Table?
    By keonglah in forum Coldfusion Database Access
    Replies: 6
    Last Post: June 13th, 02:53 AM
  2. MS Access SQL: duplicate record... ?SELECT INTO....?
    By Scotter in forum ASP Database
    Replies: 8
    Last Post: June 30th, 12:25 PM
  3. Select and delete unused symbols won't record in an action
    By Michael_Powell@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 1
    Last Post: June 25th, 11:03 PM
  4. Pop-up list to select a record?
    By D.M. Procida in forum FileMaker
    Replies: 3
    Last Post: January 7th, 01:18 AM
  5. move record from 1 table to another table
    By Jason Frazer in forum Microsoft Access
    Replies: 6
    Last Post: August 4th, 02:45 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139