Insert using joins tables
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=15401
Printed Date: 29 March 2026 at 2:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Insert using joins tables
Posted By: padoxky
Subject: Insert using joins tables
Date Posted: 08 June 2005 at 4:35am
|
Hello my friends,
Am here to seek for a help form you guys out here.
I want to know how do i insert data to my acces database using two tables and also how do i display it when i have already insert the data into my access database.
I just need a sample code for it.
Please help. ------------- NgWebDesigns |
Replies:
Posted By: michael
Date Posted: 08 June 2005 at 9:24am
|
No idea what you are talking about, you can only insert data into one table at a time, if you want to query a joined two tables to populate another that is another story, you simple do a join subquery as your value list making sure the field#'s match.
Don't get the 2nd part of your q ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: bootcom
Date Posted: 08 June 2005 at 10:27am
Why would you need to do a join to do an insert anyways  . As Michael states the only time you need to do a join is when your extracting information and not putting it back in ....Just do 2 inserts ... and all will be fine |
Posted By: michael
Date Posted: 08 June 2005 at 2:07pm
|
Well you could do something like
INSERT t1 (f1,f2,f3) Values ( (Select t2.x1,t2.x2,t3.x4 from t2 join t3 on t2.x1=t3.x1)) ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |