rss sql ru access programming
rss_sql_ru_access_programming

 -

rss_sql_ru_access_programming

 - e-mail

 

 -

LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


UNION

, 14 2015 . 16:40 +
!

adp- vba . , , , , , NULL-.
, .
, ?

, vba-.

sql = "(SELECT . AS [ ], '' AS [  / ], "
sql = sql & ". AS [-], . AS , "
sql = sql & "[].[] AS , [].[]*[].[] AS , "
sql = sql & "., [].[]*[].[]/100*[].[] AS [ ], "
sql = sql & "[].[]*[].[]+[].[]*[].[]/100*[].[] AS , . "
sql = sql & "FROM [] INNER JOIN [] ON . = . "
sql = sql & "WHERE ((([].)=" + strKey + ") AND (.)<>0) )"
'sql = sql & " UNION "
sql = sql & "(SELECT '' AS [ ], '' AS [  / ], '' AS [-], '' AS [], '' AS [], " + sW1 + " AS [], "
sql = sql & "'' AS [], " + sW2 + " AS [ ], " + sW3 + " AS [], '' AS []"
sql = sql & "FROM [] "
sql = sql & "WHERE ((([].[])=" + strKey + ") ) ); "


, + , .

http://www.sql.ru/forum/1152159/problema-v-union


— — : [1] []
 

:
: 

: ( )

:

  URL