Insert using joins tables

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
padoxky Members Profile Find Members Posts Groupie Joined: 17 June 2004 Location: Nigeria Status: Offline Points: 78	Post Options Post Reply Quote padoxky Report Post Thanks(0) Quote Reply Topic: Insert using joins tables 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

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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
	Blog \| MPG Tracker

bootcom Members Profile Find Members Posts Senior Member Joined: 26 February 2005 Location: United Kingdom Status: Offline Points: 259	Post Options Post Reply Quote bootcom Report Post Thanks(0) Quote Reply 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

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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))
	Blog \| MPG Tracker

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.