select top 1 column data from the 3 tables using joins or any other

Question

   

  Hi All,

  Can you please help me on this.

  I have tables t1,t2,t3

  common column an in 3 tables id.

 now i want select t1.colm1,t1.clom2,t2.clom1,t2.clom3,t3.clomn2 from t1,t2,t3 and  selcet top1 t1.clomn1 from t1 table and get data from 3 table using joins or any other like where condition using id column is the common for 3 tables.

please help me on this.

Advanced Thank you.

Regards,

Narasimha

Answer 1

If you're using .NET, you can get this information using the System.IO.DriveInfo class.

Check out the example in the MSDN docs:

http://msdn.microsoft.com/en-us/library/system.io.driveinfo.aspx

Answer 2

I think you can also use performance counters. Check this out: http://www.codeproject.com/Articles/8590/An-Introduction-To-Performance-Counters