Sunday, February 19, 2012

Append to Self-Join Table

I have 5 Self-Join Tables with the same structure
Table1
|--> SubjID
|--> ParentID
|--> SubjText
I want to merge my 5 tables in one table with the same structure without
lose my Tree which have many levels not only one, I need help plz?
On Sun, 6 Nov 2005 17:29:49 +0200, Islamegy wrote:

>I have 5 Self-Join Tables with the same structure
>Table1
>|--> SubjID
>|--> ParentID
>|--> SubjText
>I want to merge my 5 tables in one table with the same structure without
>lose my Tree which have many levels not only one, I need help plz?
>
Hi Islamegy,
I'm sorry, but I fail to understand your problem. Maybe it helps if you
follow up with a post that includes:
- Structure of your tables, posted as CREATE TABLE statements (including
all constraints and properties, but excluding irrelevant columns);
- Some rows of sample data to illustrate the situation (posted as INSERT
statements);
- Expected output.
Check out www.aspfaq.com/5006 too.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

No comments:

Post a Comment