"Vlad Horsun" <[EMAIL PROTECTED]> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ ñëåäóþùåå: news:[EMAIL PROTECTED] > > "Êîíñòàíòèí" > >> Hi, ìíîãîóâàæàåìûé All! >> >> Firebird-2.1.0.15692-0_win32 >> >> CREATE VIEW VW_TOVAR( >> ID, >> PROIZV_ID, >> PROIZV_NAME, >> CODE, >> NAZVANIE_ID, >> NAZVANIE) >> AS >> select >> t.ID, >> t.PROIZV_ID, >> (select val from vw_val where id = t.proizv_id and id != -5), >> t.CODE, >> t.nazvanie_id, >> (select val from vw_val where id = t.nazvanie_id and id != -5) >> from TOVAR t >> where ver = 0 >> >> select * from VW_TOVAR >> >> Âûäà¸ò >> multiple rows in singleton select > > À ïðîñòîé ñåëåêò, áåç âüþõè ? À åñëè > > (select val from vw_val where id = t.proizv_id and id != -5), > > çàìåíèòü íà > > (select val from vw_val v where v.id = t.proizv_id and v.id != -5),
ìíå òîæå êàæåòñÿ, ÷òî and id != -5 áåðåòñÿ èç TOVAR... > ñåëåêòèòü âî âüþõå èç âüþõè, äà åùå 1 çàíà÷åíèå, ýòî çà÷åì ???
