access sql
18 January 2003, 05:47 PM
#1
Scooby Regular
Thread Starter
Join Date: Jul 2000
Location: Islington
Posts: 2,145
Likes: 0
Received 0 Likes
on
0 Posts
this format sql is giving me an undefined error:
insert into tablea
(a,b,c,d)
values
((select e from tableB where tableB.field='value'),'value','value','value')
can I do this in access?
insert into tablea
(a,b,c,d)
values
((select e from tableB where tableB.field='value'),'value','value','value')
can I do this in access?
18 January 2003, 06:39 PM
#3
Scooby Regular
Thread Starter
Join Date: Jul 2000
Location: Islington
Posts: 2,145
Likes: 0
Received 0 Likes
on
0 Posts
don't worry, sorted.
stupidest rdbms ever. unless my new boss is reading this, then it's pretty ******* excellent, ultra reliable and a breeze to interface to.
stupidest rdbms ever. unless my new boss is reading this, then it's pretty ******* excellent, ultra reliable and a breeze to interface to.
Thread
Thread Starter
Forum
Replies
Last Post