Help with this query 1

[Durango122]

Hi All
cr 9.0
ms sql
i have this report and table link to =
i'm not getting the right data

if i used MS SQL to get the data i get the right one.
my sql is this
-------------------------------------
select a.terr1, uni_user
from
(select distinct th.terr1
from transaction_history th
where terr1 like 'PFS%') a
left outer join
(select terr1, uni_user, uu_ref, uu_wrk
from uni_user uu, vw_current_terr1_user vw
where uu.uni_user = vw.user_id
and uu_wrk = '00013') b
on a.terr1 = b.terr1
-----------------------------------------------
how can i get this to work in cr 9.
command or sql expression not sure what
i tried left other join on my table and no luck


thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[synapsevampire]

Create a command object with that SQL.

-k

 

[Durango122]

hi than can i link it to my main table
thanks



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[synapsevampire]

Yeah, but why not just add the main table to the command object?

It'll be slow if the linking is in Crystal.

-k

 

[Durango122]

thanks -K

Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40