> 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
