synergy46

SQLExplorer confusion...

Discussion created by synergy46 on Feb 4, 2014
Latest reply on Feb 12, 2014 by synergy46

I am trying to get a leg up on ExecuteSQL so I am starting with SQLExplorer.

 

I have two tables: Members and Drama

They are (in FM) related by their key fields: Members::KP_MemberID and Drama::FK_MemID

They are not connected in the TO in SeedCode SQLExplorer.

 

No matter how I simplify the situation I get the dreaded ?

 

What am I missing?

 

SQL1.png

Outcomes