GoldMine Tip: How to report/display all your Company Relationship Trees #goldmine

Here's a great 'SQL Query' that you can paste into your GoldMine SQL Query Window to report/display the Company Organisation Trees you have defined...

 

Select
    Case ContSupp.EXT When 1 Then LTrim(ContSupp.Address1) End [Book Headding],
Case ContSupp.EXT When 3 Then LTrim(ContSupp.Address1) End [Folder Headding],
    C1.Company,C1.Contact,C1.Key1,C1.Key5,C1.AccountNo [GM Account Number]
         From ContSupp 
     Left Join Contact1 C1 On ContSupp.Accountno = C1.Accountno
     Left Join Contact2 C2 On C1.Accountno = C2.Accountno
  Where ContSupp.Rectype = 'O'