Execute

somfaでは、以下のように直にSQLを発行できます。

発行するクエリー

1 select a.user_cd, a.user_nm, b.address, b.tel
2 from   sample1 as a, sample2 as b
3 where  a.user_cd = b.user_cd
4 

somfaでの記述

1 <?php
2 $sql = array();
3 $sql[] = 'select a.user_cd, a.user_nm, b.address, b.tel';
4 $sql[] = 'from   sample1 as a, sample2 as b';
5 $sql[] = 'where  a.user_cd = b.user_cd';
6 $somfa->execute(@implode(chr(10), $sql));
7