Question on Relationships

Hello,
I'm interested to know whats the difference between a many to one
relationship and a one to many relationship. Presuming 2 tables A and B
A (1 to many) B relationship is different with B (many to 1) A relationship?
I've thought that they're the same but I was watching a BI webcast when they
say that the logical relationship cannot be reversed...
Can someone enlighten this?They are the same relationship, just viewed from opposite perspectives.
I guess by saying the logical relationship cannot be reversed they mean
that if you can get the "1" row from a particular "many" row that does
not imply that you can then get back to the original "many" row just
given that "1" row (because there are now many rows that match up with
that 1 row). Does that make sense? (That's just a guess at what they
were trying to explain (not having any idea what they were saying
exactly) - maybe you could ask the presenter directly what they meant
precisely.)
*mike hodgson*
http://sqlnerd.blogspot.com
Nestor wrote:

>Hello,
>I'm interested to know whats the difference between a many to one
>relationship and a one to many relationship. Presuming 2 tables A and B
>A (1 to many) B relationship is different with B (many to 1) A relationship
?
>I've thought that they're the same but I was watching a BI webcast when the
y
>say that the logical relationship cannot be reversed...
>Can someone enlighten this?
>
>