How to make so I only need to specify the id once..

[Joppe A]

Hello,

I have a small problem that is probably easy to fix but it is to advanced for me as a
"newbe". In my sql-query (below) have I the ID specified twice, I wonder if there is a
easy way to solve it so I only need to write my ID once in the query?

SELECT (SELECT COUNT(*) FROM subs WHERE id=1) + (SELECT COUNT(*) FROM subs_erased WHERE
id=1);

Thanks in advance!
-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm