SQL join

[cpo...@baynetworks.com]

To all:

I am trying to do a join of two tables. I am following along with the User's
Guide get it to work but don't think that it is correct.

In table BAY.MO the SQL is SELECT MO,CLASS,NAME,PARENT,MOM,REPORTEDAS FROM
BAY.MO
In table Bay.MOM the SQL is SELECT * FROM BAY.MOM WHERE MOM = ?
For Bay.MO the Parent Relationship is empty
For Bay.MOM the Parent Relationship is Bay.Mo
For Bay.MOM the join columns is MOM = MOM

Table Bay.MOM is displayed in a grid and when I move from entry to entry in
Bay.MO the corresponding entry in Bay.MOM is highlighted. I would have
thought all I'd see for Bay.MOM is any entries that corresponded to Bay.MO
(not all of the table with the one entry hightlighted).

Am I missing something?

thanks,

Chris Powers
Bay Networks
cpo...@baynetworks.com

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading