Post reply

Query join problem

  • May 24, 2006 at 12:56 pm

    #169710

    I'm new. I'm lost.

    I'm looking to create a query in Access using a "one to one" join between a SQL2000 table's non keyed field and a local Access table's primary keyed field.

    I know Access very well. But everytime I create this query I get nothing.  I know for certain that I have data in both table that should yeild results. 

    Anyone?

     

     

  • May 25, 2006 at 4:51 am

    #639992

    perhaps posting the SQL statement you are using would help someone find what's wrong.  it also would be helpful to know the data types of the fields involved in the join.

    Dick

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply