sub qurery

[venubabu123]

Hi...,
My self Venu..,

I have written program for retrieving data in sql server 2008 but not getting required results.
And My Requirement is getting readings from table1,table2,t able3 where latest reading stored in data base which is in table3.the data stored in table 3 in the from of date and time mode in date and time column.so i want to get latest reading of the every meters.
********
thank you

[zmbd]

venubabu123,
the "it doesn't work" really doesn't help us help you.
Please post a short description of your datatables (table names are rarely enough information -- table names, fields with datatype, relationships between the tables etc)
Also having the actual SQL and some example data (you can makeup a generic set of data... just make sure it is something that reflects a real data-set) to work with will allow our membership to help.
Please include any error messages in their entirety (including number, name, description)
-z