[thelist] SQL Help Please

Mattias Thorslund mattias at thorslund.us
Fri Jan 13 16:38:04 CST 2006

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;
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.

More information about the thelist mailing list