RE: SQL PROBLEM

From: Niyi Olajide <N.OLAJIDE_at_CGIAR.ORG>
Date: Fri, 25 May 2001 00:59:53 -0700
Message-ID: <F001.0030EA1F.20010525003557@fatcity.com>

<FONT

size=2>Can you try
this:
<FONT

size=2><SPAN
class=450062506-25052001> 
<FONT

size=2>select count (1) from
(
<FONT

size=2>select 1 from table_ a where ord_id = 17 
<FONT

size=2>union

<FONT

size=2>select 1 from table_b where ord_id = 17)
<FONT

size=2>/
<FONT

size=2><SPAN
class=450062506-25052001> 
<FONT

size=2><SPAN
class=450062506-25052001> 
<FONT

size=2><SPAN
class=450062506-25052001> Hi,
 
Favour
me in suggest a hint in writing a sql for following scenaio:
<SPAN

class=500143917-24052001> 
Table
A has 2 columns ord_id and line_id
<SPAN

class=500143917-24052001> 
<SPAN

class=500143917-24052001>example rows are:
<SPAN

class=500143917-24052001> 
<SPAN

class=500143917-24052001>ord_id         line_id
<SPAN

class=500143917-24052001>17                null
<SPAN

class=500143917-24052001>null              42
<SPAN

class=500143917-24052001> 
<SPAN

class=500143917-24052001>Table  B has columns ord_id and line_id
<SPAN

class=500143917-24052001> 
<SPAN

class=500143917-24052001>ord_id         line_id
<SPAN

class=500143917-24052001>17                42
<SPAN

class=500143917-24052001>17                43
<SPAN

class=500143917-24052001>17                44

<SPAN

class=500143917-24052001> 
I have
to write a sql to count(*) from table A where ord_id=17 .. as u
see from table B line 42 is row of ord_id=17 ..so i want
<SPAN

class=500143917-24052001>count(*) should show =2 from tabel A

but if
i do count(*) from table A where ord_id=17..it shows 1.. i need
to put another condition which will check line id with TABLE
B and if it is  for this particular order ...add that also in
<SPAN

class=500143917-24052001>count(*)............. I know
scenario is little fuzzy sorry for it..but if u got my point

kindly
respond.
<SPAN

class=500143917-24052001> 
<SPAN

class=500143917-24052001>Thanks
<SPAN

class=500143917-24052001>Harvinder Received on Fri May 25 2001 - 02:59:53 CDT