Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
alter table tmp 1 add index a1 (school_id); alter table tmp2 add index a1 (geo_code); DROP table if EXISTS m_v3; Create table m_v3 AS select a.school_id, a.name, a.adreess b.geo_code, b.sco_code, CASE when sco_code is not null then 'Y' else 'N' end as check_code FROM tmp1 a left join tmp2 b ON a.school_id = b.geo_code GROUP BY 1,2;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Add a date range function to PDF Generation||9||36|
|SQL Time out only from one specific computer client||15||49|
|SQL State HYT00. Timeout expired proplem||8||37|
|Windows Server 2003 STD SP2 as a member server of 2016 domain||11||84|
Join the community of 500,000 technology professionals and ask your questions.