I have the following query, which works:

"SELECT product.productid,product.title,
        (SELECT count(pic) FROM picture WHERE picture.productid = 
product.productid AND picture.pic !='')
        AS pcx FROM product WHERE yada yada conditions....

but now I want to get more then just count(pic) from the 'picture' table.

How do I do this?

Michael

--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
-~----------~----~----~----~------~----~------~--~---

Reply via email to