Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: quick computer help plz

  
  1. #1
    Status
    Offline
    monolith's Avatar
    AOC Obsessed
    Join Date
    Jul 2006
    Posts
    2,543
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)

    quick computer help plz

    I have 2 tables in a database, i want to show only the records which dont match in both, say theyre telephone numbers, i want to display the ones out of table A which do not appear in Table B at all...

    how would i do it?

    i did it 2 weeks ago, but now i cant remember what i did.

    i def. used asp and set variables i think... but i keep getting it wrong now.

    any help appreciated... ty

    ste

  2. #2
    Status
    Offline
    bradley's Avatar
    AOC Regular
    Join Date
    Mar 2006
    Posts
    135
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    asp? php + sql? access?
    astra mk5 1.4
    19" tsw reflex, eibach 30/30, airbox/vxr intake/k&n filter, Steinmetz air intake

  3. #3
    Status
    Offline
    monolith's Avatar
    AOC Obsessed
    Join Date
    Jul 2006
    Posts
    2,543
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    asp & sql mate

  4. #4
    Status
    Offline
    bradley's Avatar
    AOC Regular
    Join Date
    Mar 2006
    Posts
    135
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    mysql or mssql?

    last question
    astra mk5 1.4
    19" tsw reflex, eibach 30/30, airbox/vxr intake/k&n filter, Steinmetz air intake

  5. #5
    Status
    Offline
    monolith's Avatar
    AOC Obsessed
    Join Date
    Jul 2006
    Posts
    2,543
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    mssql................

  6. #6
    Status
    Offline
    Simon-DTi's Avatar
    AOC Obsessed
    Join Date
    Jul 2003
    Posts
    3,463
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    select tablea.telephonenumber where tablea.telephonenumber not in (select tableb.telephonenumber);

    ^^ something like that?
    2 Door E350 CDI - OM642 power baby
    emJlZnIgdmYgZmJiYmIgeW5mZyBscm5l

  7. #7
    Status
    Offline
    bradley's Avatar
    AOC Regular
    Join Date
    Mar 2006
    Posts
    135
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    i used something like this for a project, but the code is at work and i am at home so i can't remember exactly..

    SELECT `A` FROM `TABLE` WHERE 'A' NOT IN ('B')

    try having a google for SQL IN or SQL DISTINCT

    i think that's the command you need
    astra mk5 1.4
    19" tsw reflex, eibach 30/30, airbox/vxr intake/k&n filter, Steinmetz air intake

  8. #8
    Status
    Offline
    bradley's Avatar
    AOC Regular
    Join Date
    Mar 2006
    Posts
    135
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    yeah thought it would be "not in" but i use php and MySQL so i don't know if some of the syntax is different
    astra mk5 1.4
    19" tsw reflex, eibach 30/30, airbox/vxr intake/k&n filter, Steinmetz air intake

  9. #9
    Status
    Offline
    monolith's Avatar
    AOC Obsessed
    Join Date
    Jul 2006
    Posts
    2,543
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    ty, will try

  10. #10
    Status
    Offline
    monolith's Avatar
    AOC Obsessed
    Join Date
    Jul 2006
    Posts
    2,543
    Mentioned in
    0 Post(s)
    Quoted
    0 Post(s)
    nah, got not in function in sql enterprise but its not doing diddly, its still showing me more numbers than i should have, there should be 28 missmatches, but i cant get 28

Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 5
    Last Post: 10-11-2013, 15:47
  2. Quick question for u computer ppl
    By GB in forum Chit Chat and a Warm Welcome!
    Replies: 5
    Last Post: 01-02-2007, 03:26
  3. Replies: 64
    Last Post: 26-05-2004, 21:54

Posting Permissions

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