> :)) You've got result like count(artists)*count(artworks)*count(news)? It
> is right. You cannot get result you want in one query. You must run 3
> different queries.
sure you can:
SELECT
(SELECT COUNT(artist_id) FROM artists) AS artists,
(SELECT COUNT(artworks.artwork_id) FROM artworks) AS artworks,
(SELECT COUNT(news.article_id) FROM news) AS news
as long as you don't care wether there's any relationship among these
tables...
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
