Re: Self Joining A Table

Is this homework? Sounds like homework with the question being: Write a self join for the following table...
Most people here don't do homework. You could do a google search and probably dig up an example on the web.
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"TaZ2002" <cdr.taz2k_at_ntlworld.com> wrote in message
news: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