hai everyone,
i really need someones help here... i hve a few table in my database.. but all i need is to connect table order_ms and order_dt.. order_dt is a sub table for order_ms... so here's the table

# --------------------------------------------------------

#
# Table structure for table `order_ms`
#

CREATE TABLE order_ms (
order_code varchar(8) NOT NULL default '',
order_id varchar(8) NOT NULL default '',
order_customer_code varchar(8) NOT NULL default '',
order_date datetime NOT NULL default '0000-00-00 00:00:00',
order_payment_type int(1) NOT NULL default '0',
order_payment_payment_card_code varchar(8) NOT NULL default '',
order_payment_payment_bankin_code varchar(8) NOT NULL default '',
order_payment_payment_cheque_code varchar(8) NOT NULL default '',
order_delivery_code varchar(8) NOT NULL default '',
order_delivery_charges decimal(18,2) NOT NULL default '0.00',
order_total_amount decimal(18,2) NOT NULL default '0.00',
order_remark varchar(64) NOT NULL default '',
order_display char(1) NOT NULL default 'Y',
order_create_date datetime NOT NULL default '0000-00-00 00:00:00',
order_create_by varchar(8) NOT NULL default '',
order_modify_date datetime NOT NULL default '0000-00-00 00:00:00',
order_modify_by varchar(8) NOT NULL default '',
PRIMARY KEY (order_code,order_customer_code)
) TYPE=MyISAM;

#
# Dumping data for table `order_ms`
#

INSERT INTO order_ms VALUES ('1', '', '00000018', '0000-00-00 00:00:00', 0, '', '', '', '', '0.00', '89.90', '', 'Y', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '');
INSERT INTO order_ms VALUES ('2', '', '00000024', '0000-00-00 00:00:00', 0, '', '', '', '', '0.00', '228.00', '', 'Y', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '');

#
# Table structure for table `order_dt`
#

CREATE TABLE order_dt (
dt_order_order_code varchar(8) NOT NULL default '',
dt_order_order_id varchar(8) NOT NULL default '',
dt_order_item int(1) NOT NULL default '0',
dt_order_product_code varchar(8) NOT NULL default '',
dt_order_product_price decimal(18,2) NOT NULL default '0.00',
dt_order_quantity int(1) NOT NULL default '0',
dt_order_total_amount decimal(18,2) NOT NULL default '0.00',
PRIMARY KEY (dt_order_order_code,dt_order_product_code)
) TYPE=MyISAM;

#
# Dumping data for table `order_dt`
#

INSERT INTO order_dt VALUES ('1', '', 0, '00000004', '89.90', 1, '89.90');
INSERT INTO order_dt VALUES ('2', '', 0, '00000007', '228.00', 1, '228.00');

.... all i need to do is to connect dt_order_order_code with order_customer_code... anyone hve any idea how to do it? Thank you for your precious time ;)

Example:
$aQuantity = db_query(" SELECT * FROM order_dt WHERE dt_order_order_code = ''");