Self Joining A Table

From: TaZ2002 <cdr.taz2k_at_ntlworld.com>
Date: 6 Jan 2003 12:09:11 -0800
Message-ID: <db3e4476.0301061209.151377dd_at_posting.google.com>

This is what I have to do:
A report to a user, incorporating a query that uses a self join. This should provide useful information to the user. from This table:

CREATE TABLE costume_piece(
Costume_id VARCHAR2(10) PRIMARY KEY,
Member_id VARCHAR2(10),
Character_name VARCHAR2(10),
Prod_no VARCHAR2(10),
Play_name VARCHAR2(10));

CONSTRAINT fk_cos_mem FOREIGN KEY (Member_id) references
member(Member_id),
CONSTRAINT fk_cos_cha FOREIGN KEY (Character_name) references

character(Character_name),
CONSTRAINT fk_cos_pro FOREIGN KEY (Prod_no) references production(Prod_no),
CONSTRAINT fk_cos_pro FOREIGN KEY (Play_name) references play(Play_name));

any help please Received on Mon Jan 06 2003 - 21:09:11 CET