AnsweredAssumed Answered

selfjoin sql

Question asked by FH on Jun 18, 2012
Latest reply on Jun 19, 2012 by philmodjunk

Title

selfjoin sql

Post

Hi,

how do I express a selfjoin in SQL using Filemakers 12 internal SQL syntax?

 

eg. table called 'school' with a selfjoin matching 'names' and not matching (unequal) 'ID'

 

Thanks in advance,

 

Francis

Outcomes