Joined Tables Newbie Question

[Jeff Snoxell]

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


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php