如何使用内部联接创建INSERT? [英] How do I create an INSERT into with inner join?
问题描述
这些是我的桌子:
add_user我的第一张桌子
id
fname
mi
lname
email
密码
file
等级
joboffer第二桌
id
datetime
jobtitle
描述
资格
等级
user_applications第3桌
id
电子邮件
jobtitle
file
level
我想从前2个表中获取数据,(add_user和joboffer),电子邮件,作业标题和文件,并将其粘贴到另一个表user_applications,说实话,我不知道如何插入内部联接,或不熟悉如何做到这些事情,所以我希望你能帮助我。
提前谢谢:))
我尝试了什么:
什么都没有,我不知道这个hehe抱歉的目的:))
these are my tables:
"add_user" my first table
id
fname
mi
lname
email
password
file
level
"joboffer" 2nd table
id
datetime
jobtitle
description
qualification
level
"user_applications" 3rd table
id
email
jobtitle
file
level
I wanna get the data from the first 2 tables, (add_user and joboffer), the email, jobtitle and file and paste it to another table which is the user_applications, to be honest, i dont know exactly how to do an insert into with inner join, or not familiar on how to do those things, so i hope you could help me.
Thanks in advance :))
What I have tried:
nothing, i dont know exactly the purpose of this hehe sorry :))
推荐答案
请参阅CodeProject问题:如何制作INSERT INTO语句中的INNER JOIN? [ ^ ]
See CodeProject question: How do I make a INNER JOIN inside a INSERT INTO statement?[^]
这篇关于如何使用内部联接创建INSERT?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!