Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: Problem with database under Win32

by NetWallah (Canon)
on Nov 22, 2003 at 07:04 UTC ( #309122=note: print w/replies, xml ) Need Help??

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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://309122]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (5)
As of 2022-01-27 09:50 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (70 votes). Check out past polls.