<div>
<div class="content wysiwyg-content">
Hey guys i have this sql query:<br />
<br />
select DISTINCT UPPER(r_name) as r_name, UPPER(address) as address, area, location, p_code, tel, website, '&lt;b&gt;'+ UPPER(r_name) + '&lt;/b&gt;' + '&lt;br&gt;' + UPPER(address) + '&lt;br&gt;' + area + '&lt;br&gt;' + IsNull(location,'') + &nbsp;'&lt;br&gt; CONTACT: ' + tel &nbsp;as InfoWindowText, Latitude as Lat, Longitude as Lng FROM dbo.ballito where active='Yes'&quot;;<br />
<br />
now i want to select the same data but two tables.<br />
<br />
the coloums are the same 
</div>
</div>


Hey guys i have this sql query:

select DISTINCT UPPER(r_name) as r_name, UPPER(address) as address, area, location, p_code, tel, website, '<b>'+ UPPER(r_name) + '</b>' + '<br>' + UPPER(address) + '<br>' + area + '<br>' + IsNull(location,'') +  '<br> CONTACT: ' + tel  as InfoWindowText, Latitude as Lat, Longitude as Lng FROM dbo.ballito where active='Yes'";

now i want to select the same data but two tables.

the coloums are the same 

sql two tables

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.