View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martha Chau Martha Chau is offline
external usenet poster
 
Posts: 1
Default Using Microsoft query through Excel

I am using Microsoft query through Excel to pass data from
a Sybase database. I want to use the OR command in my SQL
code but when I do this, executing this code is extremely
slow. Here is a sample of my code (there is also a prompt
for the user to input data) :

select top.cpty_name, sub.cpty_name
from top.cpty_acct ca,
sub.cpty_acct sub
where (top.id_party = sub.id_party
OR top.nm_acc_cpty_grp = sub.nm_acc_cpty_grp)
and top.id_active='Y' and top.nm_acc_cpty=?