From: Jeff Snoxell
Date: December 11 2002 3:12pm
Subject: Joined Tables Newbie Question
List-Archive: http://lists.mysql.com/mysql/127214
Message-Id: <5.2.0.9.0.20021211150255.027efae8@pop.freeserve.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

Hi,

I've worked with a database system in the past that allows you to setup 
permanent joins between two tables in a database such that if you select 
record 1 say on a parent table and then add records to a child table, the 
child table automatically knows that this record is a sub-record of record 
1 in the parent. Thus I can have databases with table structures like:

Customers: Orders: OrderedItems

Without having to always execute complex SQL queries every time.

Can I do anything with MySQL to make it act in the same way?

Many thanks,


Jeff