Click here to Skip to main content
15,882,329 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how can acess data from another table and insert another table procedure throws,,,They How Can use Select Statemnet
Posted
Updated 13-Mar-14 3:41am
v2
Comments
CHill60 13-Mar-14 9:06am    
Your question is not clear. Use the Improve question link to provide us with some more detail. What are you trying to do and what have you tried so far?
OriginalGriff 13-Mar-14 9:44am    
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Perhaps an example of what you are trying to achieve would help?
Use the "Improve question" widget to edit your question and provide better information.

I think you are asking about how to insert data to any table using select statement...

please refer below link...

http://www.w3schools.com/sql/sql_insert_into_select.asp[^]
 
Share this answer
 
I think u want to select data from second table and insert those values into first table and then selecting values from first table

Ex:

Table 1: A
Table 2: B

INSERT INTO A
Select *(All Values) FROM B


Now, SELECT * FROM A-- U can see all selected values
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900