Click here to Skip to main content
11,713,864 members (85,804 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Oracle
Sir,
I have two Table Name Table1 and Table2 as below:-
Table1
Mobile Remarks


Table2
Mobile Name Fname Address


Now I want that table2.mobile data should copy into the table1.mobile data and rest of the columns of Table2 data should be copy in the table1.remarks column.
Please send me query



Sir,
As you send the query am using in MS-Access 2007 but its giving error message that Syntax error in query expression "select mobile".
Posted 20-Jan-13 22:45pm
Edited 21-Jan-13 23:54pm
v3
Comments
OriginalGriff at 21-Jan-13 4:46am
   
Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know
Richard MacCutchan at 21-Jan-13 4:46am
   
This is a repost; see below in QΑ list.
OriginalGriff at 21-Jan-13 4:48am
   
I was just telling him that when you were telling me! :laugh:
OriginalGriff at 21-Jan-13 5:00am
   
Richard, did you edit that?
I got strange characters in the email, that I don't normally:
"This is a repost; see below in QΑ λιστ."
If you didn't, then I'll mention it to Chris in Sugs'n'Bugs.
Richard MacCutchan at 21-Jan-13 5:02am
   
Sorry I hit my "switch language" keys by mistake so it came out as Γρεεκ characters.
OriginalGriff at 21-Jan-13 5:05am
   
I am not going to ask why you have Cyrillic as one of your options! :laugh:
Richard MacCutchan at 21-Jan-13 5:12am
   
I don't, but I do have Greek. I started learning it a few years ago but didn't keep up with the lessons. It remains on my todo list.
OriginalGriff at 21-Jan-13 4:47am
   
And don't repost!
If you have extra data to add to your question, use the "Improve question" widget to edit your question and provide better information.
Posting the same question twice is rude, and can slow a response dramatically.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try out with below mentioned query.

INSERT INTO TABLE1 (Mobile, Remarks) VALUES (SELECT MOBILE, NAME||' '||FNAME||' '||ADDRESS FROM TABLE 2)

Hope this will help you..
  Permalink  
Comments
Rajesh Kinger at 22-Jan-13 5:22am
   
Sir,
It's still not working its giving error message that "Sytax error in query expression 'select mobile'.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 330
1 CHill60 315
2 OriginalGriff 165
3 Andy Lanng 138
4 KarstenK 110
0 Sergey Alexandrovich Kryukov 365
1 CHill60 335
2 OriginalGriff 245
3 Andy Lanng 173
4 Richard MacCutchan 150


Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100