[RBASE-L] - Union Select Question

[Steve Breen]

I know I am not close.
 
Any ideas or help would be appreciated.
 
Clear var vTestTest1 

Set var vTestTest1 = 'test test'

choose vcustcont from #values for +
'.vTestTest1', 0 from custcontacts where count = 1 +
union all sel +
( (LJS(CC_contact, 20)) +
& (lJS(CC_OfficeExt, 5)) & (RJS(CC_Mobile1, 12)) +
& (RJS(CC_HomePhone, 14)) ) from CustContacts +
where custnub2 = .This_Custnub2 and CC_ActiveStatus = 'Y' +
ORDER BY CC_CallOrder AT 2 1 TITLE 'Contact     Office     Ext
Mobile#         Home#'

 

Steve