[thelist] SQL Help Please

[Mattias Thorslund]

Matt Warden wrote:

> Rob,
>
> I'm having a little trouble understanding the problem. Is there any way
> you can give us the data in View A and View B, specifically the
> commission_ids?


I'd like to see the results of:

SELECT commission_id, [Inv #] FROM [view A] WHERE commission_id = @repid;
and
SELECT commission_id, [Inv #] FROM [view B] WHERE commission_id = @repid;


In passing, [Inv #] isn't a name I would ever use since it requires
those square brackets all the time.