List:General Discussion« Previous MessageNext Message »
From:SGreen Date:February 22 2005 5:32pm
Subject:Re: How to make so I only need to specify the id once..
View as plain text  
"Martijn Tonies" <m.tonies@stripped> wrote on 02/21/2005 10:20:28 AM:

> 
> 
> > 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!
> >
> >
> 

It should if he changed the INNER JOIN to a LEFT JOIN.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Thread
How to make so I only need to specify the id once..Joppe A21 Feb
  • Re: How to make so I only need to specify the id once..Johan Höök21 Feb
  • Re: How to make so I only need to specify the id once..Martijn Tonies21 Feb
    • Re: How to make so I only need to specify the id once..Johan Höök21 Feb
    • Re: How to make so I only need to specify the id once..SGreen22 Feb