Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

access sql

Thread Tools
 
Search this Thread
 
Old Jan 18, 2003 | 05:47 PM
  #1  
Fosters's Avatar
Fosters
Thread Starter
Scooby Regular
 
Joined: Jul 2000
Posts: 2,145
Likes: 0
From: Islington
Angry

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?
Reply
Old Jan 18, 2003 | 05:54 PM
  #2  
DazV's Avatar
DazV
Scooby Regular
 
Joined: Jun 2000
Posts: 3,783
Likes: 0
Post

Microsoft in their wisdom produced their OWN version of SQL to run on Access.

Haven't touched it in ages, so can't help you I'm afraid.
Reply
Old Jan 18, 2003 | 06:39 PM
  #3  
Fosters's Avatar
Fosters
Thread Starter
Scooby Regular
 
Joined: Jul 2000
Posts: 2,145
Likes: 0
From: Islington
Post

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.

Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
JimBowen
ICE
5
Jul 2, 2023 01:54 PM
TylerD529
General Technical
2
Oct 9, 2015 01:53 AM
Littleted
Computer & Technology Related
4
Sep 25, 2015 09:55 PM
Hangarrat93
Insurance
11
Sep 25, 2015 08:42 AM
farmerwrx
Computer & Technology Related
14
Sep 10, 2015 11:59 AM




All times are GMT +1. The time now is 01:49 PM.