By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 993 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

SQL Troubles

P: n/a
Could anyone tell me what is wrong with this statement and if it is
possible to use?

INSERT INTO tblConditionLine (dealID) VALUES (SELECT MAX(dealID) FROM
tblDeal)

Thanks!

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try

INSERT INTO tblConditionLine ([dealID]) SELECT MAX([dealID]) FROM tblDeal

hth

"Beacher" <be*****@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Could anyone tell me what is wrong with this statement and if it is
possible to use?

INSERT INTO tblConditionLine (dealID) VALUES (SELECT MAX(dealID) FROM
tblDeal)

Thanks!


Nov 13 '05 #2

P: n/a
Thanks alot, works great :)

Nov 13 '05 #3

P: n/a
Beacher wrote:
Thanks alot, works great :)


B, are you using the Access query design window? What I always do when
I'm not sure is rig up the statement I want using the query design
window and then switch to SQL view and there ya go! 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.