how to insert recored from two diffirent table into one table.

Question

0.00/5 (No votes)

See more:

Hii,

i have 3 tables:= Contects(Coloum:ContentID(pk) identity,contenttext varchar)

Sentence( Coloumn:SentenceId(pk) identity,Sentencetext varcahr)

Contentsentence(Coloumn: ContentID int (pk),SentenceId int (pk),orderno int)

i want to write insert query that insert record of contenid of content table into Contentsentencetable and sentenceid of sentence table into Contentsentencetable and also give orderno so how can i do that???)

(note:ContentID and SentenceID Are combined Primary key of the ContentSentence Table)

please provide me sql query so i can use it in my code.

Posted 1-Mar-15 22:56pm

vatsaldesai

Add a Solution

Comments

_Asif_ 2-Mar-15 5:19am

How do you link a specific Content Id with a Sentence id?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Member 11478643 · Answer 1 · 2015-03-01T23:30:00

Solution 1

if third table has also its own primary key..than we can use this query for inserting record

Insert into c.contenttext, s.Sentencetext,cs.orderno
FROM Contects c,Sentence s,Contentsentence cs
where c.Contects.ContentID =cs.Contentsentence
And cs.ContentsentenceID=s.SentenceId

Posted 1-Mar-15 23:30pm

Member 11478643

Comments

vatsaldesai 2-Mar-15 5:41am

i have to insert ContentId & sentenceid into table ContentSentence. ContentId feild get from Content table & sentenceid feild get from sentence table.

vatsaldesai 2-Mar-15 6:05am

& also i have to add id not text into table hole table has datatype int.

vatsaldesai 2-Mar-15 6:21am

I have write this queires for above problem and but problem is given that union store value into one coloum not in diffreent coloum so what to do for insert value into diffrerent coloumn: "INSERT INTO ContentSentences(ContentID,SentenceID)(SELECT ContentID FROM Contents WHERE ContentText LIKE '" + dt1.Rows[i]["SentenceText1"].ToString() + "'%) UNION (SELECT SentenceID FROM Sentences SentenceText LIKE '" + dt1.Rows[i]["SentenceText1"].ToString() + "'%)";

Magic Wonder · Answer 2 · 2015-03-02T00:42:00

Solution 3

Hi,

Find here single query for your requirement

SQL

INSERT INTO Contentsentence(ContentId, SentenceId)
SELECT ContentID,SenetenceId from 
Contects, Sentence
WHERE contenttext='Your Text'
AND Sentencetext='Your Text'
--Kindly note that these where conditions are not enough to select required data and insert it. You have to maintain some relationship between Contects, Sentence table.

Check your requirement and table structure properly.

Hope this will help you.

Cheers

Posted 2-Mar-15 0:42am

Magic Wonder

Comments

vatsaldesai 3-Mar-15 1:58am

hi magic wonder i have tried your query its not working properly and table have PK_ FK relationship like Contentsentence have relationship with Contents table using ContentID.

Magic Wonder 3-Mar-15 7:41am

Hi Vatsal,

As i written in my comment that you have to re-think as well re-design table structure.

vatsaldesai 3-Mar-15 8:15am

yep.. but if you find perfect solution please tell...

Thank You...

Magic Wonder 4-Mar-15 0:45am

Look i can try the "PERFECT" solution based on your inputs only.

vatsaldesai 4-Mar-15 0:52am

ok so which inputs you required??