How can I query the last record only? 1

[ZPlay]

I am trying to insert into a table the last record from another table. I tried this statement but all I got was an error.

INSERT INTO t1 SELECT * FROM t2 ORDER BY id DESC LIMIT 1

Is there another way to do this?

 

[braindead2]

INSERT INTO t1 SELECT * FROM t2 where id = max(id)

 

[tlbroadbent]

You can also use this.

INSERT INTO t1
SELECT Top 1 *
FROM t2
ORDER BY id DESC Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[ZPlay]

Well I tried Braindead2's solution first and Access gae me this error message:

cannot have aggregate function in WHERE clause (id=max(id))

I then tried tlbroadbents method and that seems to work perfectly. Thanks for your responses and help.