hi,im really new to MySQL,can some one help me in joining table pls...i hv 2 tables,customer table and record table
customer table with CustomerID,Customer Name,CustomerAddress,
record table with RecordID,CustomerID,Date,
how to make the CustomerID in record as foreign key? how to join that two tables so that record will be deleted when i delete the customer id? :sad:
i hope u guys could give me a hand :cry: thanks!