now...
I don't have any other way of getting to the count, that's the problem there
isnt anything else in the vehicle table that links back to the company table
that has the guid that links back to the crm system, and its guid for the
company, and then the order based on the account number, and the sales order
details, based on the sales order number.
maybe I just cant do it with the current table layout. its like, the first
part of the query is locking the result set in regardless of what else
matches...
heck...ill try your plan, its how I built the thing in the first place
tho'....cause
that's how I trouble shoot too :( so maybe again might work, ill try it
again.
is there any reason that the first join would be sooo commanding in regard
to its relentless match regardless of the where clause?
tony
-----Original Message-----
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 12:22 AM
To: CF-Talk
Subject: Re: query question
What usually helps me in a case like this is to simplify the query (if you
can).
1) Take out all the joins
2) add them back one at a time
Kinda' build the complex query in a series of simple steps..
Do you have a interactive SQL client that you can use to do this?
It looks like you are using SQL-Server, No?
Dick
On May 6, 2004, at 8:59 PM, Tony Weeg wrote:
> ok, I did this.
>
> I get everything different, but the id number from the table where
> the count comes from, the id number of the 1 vehicle that is in
> there...it has a different productId, I see the two different
> productId's, it has a different salesOrderDEtailId, they both have
> the same salesOrderId...this isnt making sense....
>
> hmmm
>
> tony
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
