in reply to Problem with database under Win32

Oh - here is a third, and perhaps simpler option - Combine the queries to get what you want like this :

select * from table2 where id =(select max(id) from table)

Untested (Because I don't have access to your database), but I have used SQL syntax similar to this.

Replies are listed 'Best First'.
Re: Re: Problem with database under Win32
by l3nz (Friar) on Nov 22, 2003 at 10:57 UTC
    This is a subquery approach - I used it first, but query resolution gets much slower and query in itself gets way messier.