Results 1 to 3 of 3

Thread: [RESOLVED] Error when doing JOIN

  1. Jul 13th, 2006, 09:24 AM #1
    mlosso
    mlosso is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2006
    Posts
    97

    Resolved [RESOLVED] Error when doing JOIN

    When I try to do a INNER JOIN in ACCESS 97, It won't let me user Primary Keys and compare them with foreign keys, and I get a datatype mismatch errror. Anyone know why?
    Reply With Quote Reply With Quote
  2. Jul 13th, 2006, 09:27 AM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Error when doing JOIN

    What are the two datatypes of the columns in those two tables?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  3. Jul 13th, 2006, 10:07 AM #3
    mlosso
    mlosso is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2006
    Posts
    97

    Re: [RESOLVED] Error when doing JOIN

    The query just wasn't right. I had a nested INNER JOIN of about 3-4 levels, so it was getting a little confusing. Got what I wanted though...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width