Post reply

Showing Duplicate Records

  • April 16, 2006 at 12:58 am

    #112994

    Hi

    When i run query on my table it's showing me duplicate records.

    When i joined two tables with inner join it work like cross join eg. if i have 3 rows in both tables , showing me 9 rows.

    I have duplicate records even in single table also but this is only happened when i run query otherwise in actuall table i have only unique records.

    It's look like that i have double result for one query because every field is duplicate.

    Thanks

     

    Vandy 

  • April 18, 2006 at 3:54 pm

    #632975

    Please post your query.

    Greg

    Greg

  • April 19, 2006 at 9:58 am

    #633087

    ..as well as ddl & sample data...







    **ASCII stupid question, get a stupid ANSI !!!**

  • April 20, 2006 at 10:23 am

    #633316

    My query is :

    Select * From Test

    To check the system i made one table having only three rows in EM it's showing me 3 lines but when i run my query on query analyzer showing me 9 rows.

    Thanks

    Vandy

     

  • April 20, 2006 at 8:35 pm

    #633400

    well - you talked about an inner join in your first post...what is the actual query that you run in QA ?! Also, could you post some sample data from both the tables ?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • April 25, 2006 at 9:17 am

    #634068

    There's no way a table with 3 rows will return 9 rows from running a query with only a SELECT * and no where clause or join to another table. There has to be more to this mystery.

  • April 25, 2006 at 9:21 am

    #634070

    a mystery that shall remain unsolved until Vandy makes a comeback..







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 7 posts - 1 through 6 (of 6 total)

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