[sqlite] Getting an Array or list in a select statement...

[jose isaias cabrera]

Greetings.
So, I know that I can do a single select and get a list of the different 
items found on a column, but what I would like to do is to get this same 
list on another select statement.  Let me explain;

I have this select statement,

"select ProjID,
      cust,
      proj,
      PClass,
      PSubClass,
      min(bdate),
      max(ddate),
      max(edate),
      lang,
      vendor,
      sum(invoice),
      sum(ProjFund),
      sum(PMTime),
      A_No from LSOpenJobs
where ProjID = 24
AND
 (
   (bdate BETWEEN '2007-09-01' AND '2007-09-01') AND
   (ddate BETWEEN '2007-09-01' AND '2007-09-01') AND
   (edate BETWEEN '2007-09-01' AND '2007-09-01')
 )
AND
 PClass!='Quote' group by ProjID;";

And this is working fine.  However, I would like to get a list of all the 
different PSubClass items found on this select statement.  Can this be done 
on this select or do I have to do the single select to get this item also?

thanks,

josé 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------