sql two tables
Posted on 2011-09-08
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