C
CJA
Hi,
I have two tables. One is a "sale_details" like this
sales# date item
1 16-12-2006 mobile phone serial#123
2 16-12-2006 computer serial#456
3 16-12-2006 printer serial#789
other is a "serial#" table like this
item serial# sales_date sales#
mobile phone 123
computer 456
printer 789
I need to create some procedure (update query???) for once a week update
table "serial#" with corresponding sales_date and sales# from table
"sale_details"
Thanks for helping!!!
CJA
I have two tables. One is a "sale_details" like this
sales# date item
1 16-12-2006 mobile phone serial#123
2 16-12-2006 computer serial#456
3 16-12-2006 printer serial#789
other is a "serial#" table like this
item serial# sales_date sales#
mobile phone 123
computer 456
printer 789
I need to create some procedure (update query???) for once a week update
table "serial#" with corresponding sales_date and sales# from table
"sale_details"
Thanks for helping!!!
CJA