make relationship on tables

[alternative]

any one can teach me how to make relationship between 'class' and 'member' table?

i wanna join both column named 'classID'

Thanx in advance.

[toma42]

create table class (
class_key int primary key,
name varchar(40)
);

create table member (
member_key int primary key,
ref_class int references class(class_key),
name varchar(40)
);

This doesn't use your classID because of personal experience with columns named id and mixed case column names.

This code is SQL 92 compliant. That means it won't work on a default mysql installation.

[alternative]

hm..i am using the phpdev 4 NT version.

By the way, do you have any new ways to do that?