~~~~~~~~this statements is to get concatenated data from vEstimates by CustomerID~~~~~~~~~~~~~~~~

select 'Date : ' + convert( varchar(10),processDate,101) + ' Ref. Num : ' + isnull(RefNum,'')  + ' -- '   + isnull(Tranmemo ,'')from vEstimates


~~~~~~~~this statements is for binding vUsers to vCompany to get the Company name~~~~~~~~~~~~~~~~

SELECT     vUsers.NameSummary, vUsers.Fname, vUsers.Lname, vUsers.Mname, vCompany.NameSummary AS Expr1
FROM         vUsers LEFT OUTER JOIN
                      vCompany ON vUsers.FkNameIDCompanyID = vCompany.PkNameID


~~~~~~~~this statements is for joining  vCompany,vCities,vStates & vCountry to get CityName state, and country~~~~~~~~~~~~~~~~

SELECT     vCompany.PkNameID, vCompany.NameSummary, vCompany.Address1, vCities.NameSummary AS Expr1, vStates.NameSummary AS Expr2, 
                      vCountries.PkNameID AS Expr3
FROM         vCompany INNER JOIN
                      vCities ON vCompany.FkCityID = vCities.PkNameID INNER JOIN
                      vStates ON vCities.FkNameIDStateID = vStates.PkNameID INNER JOIN
                      vCountries ON vStates.FkNameIDCountryID = vCountries.PkNameID


SELECT     PkNameID, NameNo, NameSummary, AboutUs, CompanyPractice, InsuranceInfo, Certifications, OrganizationsMember, Awards, Affilications, Address1, 
                      FkCityID, FkStateID, FkCountryID
FROM         vCompany