Or you could also do this. SELECT LTA FROM TABLE A WHERE ID IN (SELECT B.ID FROM TABLE B);
i hope this what your looking at, please let us know. regards anandkl On 3/30/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Rakaha, You have a cursor , select id from table_name and then have a loop where in you select values of LTA for each id got from the above cursor, close the loop once all the ID have been processed. regards anandk On 3/30/07, raksha <[EMAIL PROTECTED]> wrote: > > > How to retrieve data from three consecutive tuples until th end of the > database.Such that suppose the field name is ID and I want to retrieve > data > from another field LAT such that at a time LAT values for ID's 1,2,3 are > taken then for 3,4,5 then for 4,5,6 so on till table ends. > -- > View this message in context: > http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875 > Sent from the MySQL - General mailing list archive at Nabble.com<http://nabble.com/> > . >