Posted by jannoergaard on 04/04/06 23:09

Hi there

As I recall the statement it's something like this

Select distinct dbo.Account.AccountNo as AccountNo
>From dbo.Account inner join dbo.Groups
On dbo.Groups.AccountFrom <= dbo.Account.AccountNo AND
dbo.Groups.AccountTo >= dbo.Account.AccountNo

Hope you have a solution for me. I have tried different ways but don't
seme to get it right.
BR /Jan

• Next in forum: Re: String Comparison using "Score Method"
• Prev in forum: Scheduling DTS Package using a stored procedure problem
• Thread view: Re: How to make correct join

[Reply to this message]