Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    66

    Unanswered: how to write this query

    i have two tables

    table 1:Copy Of TISCO QCC2
    fields : MOTHER COIL and COIL NO

    table 2:batch comp
    fields : batch no

    i want the query result that it should show the list of [batch no] which do not match with the fileds from table 1 MOTHER COIL and COIL NO

    that means from table 2:field [batch no] is compared with table1 fields MOTHER COIL and COIL NO and show the list where its not matching

    sql view attached but this is not what i want


    SELECT [Copy Of TISCO QCC2].[MOTHER COIL], [Copy Of TISCO QCC2].[COIL NO], [batch comp].[batch no]
    FROM [batch comp] LEFT JOIN [Copy Of TISCO QCC2] ON [batch comp].[batch no] = [Copy Of TISCO QCC2].[COIL NO];
    Attached Files Attached Files
    Last edited by eddi; 01-10-13 at 07:13. Reason: data attached

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use the query wizard to find mismatched / missing values
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2011
    Posts
    66

    healdem thanks for reply

    iam not able to do still iam trying

    if i go to join properties i want like this condition

    include all records from table2 and only those records form table 1 where joined fileds are not equal

    can this be done

    because one field should check with two fields and give mismatch result

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    the mismatched query works on one column, but get it workign on one column
    then look at the SQL and mopdify the query so it does work
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Sep 2011
    Posts
    66

    can you pls look in the database

    pls look in to the data base

    how to compare two columns with one column
    Attached Files Attached Files

  6. #6
    Join Date
    Sep 2011
    Posts
    66

    Thanks got it

    I GOT THE RESULTI CREATED 2 queries of mis match
    them created a third query for result named final result
    Attached Files Attached Files

Posting Permissions

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