On Thu, 9 Nov 2000 13:30:49 +0700, [EMAIL PROTECTED] (Paul Hastings) wrote:
>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...
Thanks Paul and Nick... works great!
K.
______________________________________________________
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
