Redundant Data RRS feed

  • Question

  • Dear All,

    I use Primary KEY ID int IDENTITY PRIMARY KEY while creating tables , problems occur when i want to see the values using this command

    com3.CommandText = "SELECT * FROM UserInfo,OS,ProcessorInfo,RAM,Harddisk WHERE(Datee =(SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS Expr1))";

    it show me lots of redundant data ,with same ID , i want to show the single data of each Unique ID
    Sunday, March 7, 2010 11:42 PM


All replies