17 kensington st | east perth | wa 6004 | Australia | w printforce.com.au | e rsingh@printforce.com.au 22 Select Statements Sales Method select 'Sale' UNION select 'Auction' UNION select 'Lease' UNION select 'Tender' Icon Value SELECT IconValue FROM SB_DEP_OtherIconsHor where IconSelection='$IconSelection$' Icon Selection Select IconSelection from SB_DEP_OtherIconsHor Icon Frame SELECT 'Root\RayWhite\CommonVariableImages:'+ IconFrame FROM SB_DEP_OtherIconsHor where IconSelection='$IconSelection$' SelectSalesRep1 select distinct name from sales_team where client_id=$AccountId$ Sales Rep1Name select '$SelectSalesRep1$' Col1 SalesRep1Mobile Select Top 1 phone1 from sales_team where name='$SelectSalesRep1$' and client_id=$AccountId$ SalesRep1Email Select Top 1 email from sales_team where name='$SelectSalesRep1$' and client_id=$AccountId$ Select Sales Rep1 select distinct name from sales_team where client_id=$AccountId$ SakesRep2Name select '$SelectSalesRep2$' Col1
RkJQdWJsaXNoZXIy MTI3ODI1