AS CON175
FROM $tbl2
WHERE $tbl2.Dept='$rcc'
AND $tbl2.Net>0";
Hope it helps
eLFeR...
---Original Message---
From: Dillon, John
Date: Jueves, 21 de Agosto de 2003 11:03:51 a.m.
To: [EMAIL PROTECTED]
Subject: [PHP-DB] DISTINCT not working
Any ideas on
Any ideas on why the DISTINCT would not work in the following testing code:
$query="CREATE TABLE IF NOT EXISTS temp3TEMP
SELECT DISTINCTROW ROUND($tbl2.Net*.175,2) AS ExpNet175,
CONCAT($tbl2.Journal,$tbl2.Description) AS CON175
FROM $tbl2
WHERE $tbl2.Dept='$rcc