var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Share data between two tables ?
Hi, my second question !, is it possible and how would I share data between two existing tables. ie: Customers Table and Orders Table.
I need to have the contents of some fields from customers and copy them to replica fields in orders. I'm very, very new to this and basically been dropped in it at te deep end.
Assistance would be very grateful.
MySQL V 5.1.30.
it is possible, with a trigger, but it is a very bad idea
Originally Posted by J#xx
instead, why not use a foreign key to relate the order to the customer, and use a join query when you want to show this "shared" data