| transfer data from one table to another [message #291950] |
Mon, 07 January 2008 05:25  |
ashraf_al_ani
Messages: 92
Registered: October 2007
Location: Iraq
|
Member |
|
|
Dear all
I have 2 tables the first one has information about a catogary (id,name,price,totals) the secon one has information for the buyer (name,id,name,price,qty,...)
can I get the information in table 1 to table 2 when i choose the id in table 2 (name,price)
by using a procedure????
best regards
|
|
|
|
|
|
|
|
|
|
| Re: transfer data from one table to another [message #292409 is a reply to message #291950] |
Tue, 08 January 2008 21:53  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I assume that this is an assign question.
You need three tables "catogary", "buyer", and a 'cross reference' table that by storing the 'id' of the "catogary" and the 'id' of the "buyer" would then contain the number of items purchased and their date. The rest (total price, etc) you derive at run time.
(By the way you can't have two fields both called 'name' in the second table).
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
