Hi..

These are my seperate select statements that I would like to relate...

I am unable to return a hierarchical data set for the following.

Query 1
--------
SELECT Name FROM Customer


Query 2
-------
SELECT Name,IndividualChars FROM CustomerDetails



I want to relate Name from Query 1 to Name in Query 2... This does not seem to work....

Is there some rule that you can only relate 2 fields that are Primary Keys?

Thanks a bunch,

Alvin