> Hi,
> why not try:
> SELECT COUNT(s.Id)+COUNT(se.Id)
> FROM subs s
> INNER JOIN subs_erased se ON s.Id=se.Id
> WHERE s.Id=1;
>
> /Johan
This won't return the same result if there's no entries
in "subs_erased" for the ID = 1.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
> Joppe A wrote:
> > 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!
>
>
----------------------------------------------------------------------------
----
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
