Connecting 2 simple queries into one

[Anon]

Hi
my problem is that the following statement doesn't work, even thoug when I execute SQL_1 and SQL_2 separetlly it works fine.

SQL_1 = "SELECT COUNT() AS ACTIVE_LINKS FROM TABLE_LINK WHERE ACTIVE = 1"
SQL_2 = "SELECT COUNT() AS UN_LINKS FROM TABLE_LINK WHERE ACTIVE = 0"
SQL = SQL_1 & " UNION " & SQL_2

Any ideas ?

[pilyad]

Try

SQL = $SQL_1." UNION ".$SQL_2;

Arvind

Vladimir wrote:

Hi
my problem is that the following statement doesn't work, even thoug when I execute SQL_1 and SQL_2 separetlly it works fine.

SQL_1 = "SELECT COUNT() AS ACTIVE_LINKS FROM TABLE_LINK WHERE ACTIVE = 1"
SQL_2 = "SELECT COUNT() AS UN_LINKS FROM TABLE_LINK WHERE ACTIVE = 0"
SQL = SQL_1 & " UNION " & SQL_2

Any ideas ?

[pilyad]

UNION is implemented in MySql-4.0.0 if you are using one.

Arvind

Arvind Deshpande wrote:

Try

SQL = $SQL_1." UNION ".$SQL_2;

Arvind

Vladimir wrote:

Hi
my problem is that the following statement doesn't work, even thoug when I execute SQL_1 and SQL_2 separetlly it works fine.

SQL_1 = "SELECT COUNT() AS ACTIVE_LINKS FROM TABLE_LINK WHERE ACTIVE = 1"
SQL_2 = "SELECT COUNT() AS UN_LINKS FROM TABLE_LINK WHERE ACTIVE = 0"
SQL = SQL_1 & " UNION " & SQL_2

Any ideas ?