Click here to Skip to main content
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 23:45pm
Edited 22-Jan-13 0:54am
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 Maciej Los 315
1 OriginalGriff 273
2 Aajmot Sk 224
3 Marcin Kozub 210
4 Richard MacCutchan 200
0 OriginalGriff 7,853
1 Sergey Alexandrovich Kryukov 7,107
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,790


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 22 Jan 2013
Copyright © CodeProject, 1999-2014
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