how sql subquery works

join shbcf.ru