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??

[quoted text, click to view]

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
--