How To Insert Table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How To Insert Table

Author

Topic

mrdotnetid
Starting Member

8 Posts

Posted - 2006-12-06 : 08:34:59

Hello,
I have 2 table

One ---> tbCustomer with Columns CustId, CustName, Address
Two ---> tbOrders with Columns OrderId, CustId, Qty, ProductId

In my Application (Textbox) I was show CustName. Know I wan't To Insert tbOrders (OrderID, CustId, Qty, ProductId) with Parameter CustName In my Textbox. Please Help How To do it in MS Access.

Thx.

Rudianto

Norwich
Posting Yak Master

158 Posts

Posted - 2006-12-06 : 08:50:21

I'm not sure what the question is but this is how you'd retrieve the custid and the tbOrders information.
Substitute the Parameter with your CustId

Select c.CustId, o.OrderId, o.Qty, o.ProductId
from tbCustomer c
Inner Join tbOrders o
On c.CustId = o.CustId
where c.CustId = Parameter

Regards
N

The revolution won't be televised!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-06 : 10:03:04

http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-06 : 10:08:32

Duplicate post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75967

Peter Larsson
Helsingborg, Sweden

sacko_ax
Starting Member

21 Posts

Posted - 2006-12-06 : 11:15:39

so i take it this is a homework question then

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-12-06 : 23:37:01

quote:
Originally posted by sacko_ax

so i take it this is a homework question then

No doubt

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources