"CFI" <anonymous@discussions.microsoft.com> wrote in message
news:7ee101c4d123$49c8bf50$a401280a@phx.gbl...
> Hi,
> Your help would be highly appreciated! I have a next kind
> of problem.
>
> I have two tables
>
> A
> B
>
> A table includes some information about production.
> Example product A has been made in two days, so
> information i need is on a two lines and both lines has
> different date information(20.11.2004 and 21.11.2004).
>
> On a table B I have information i need, to be sure that
> the production is ready and the product has been made. Now
> I join A and B tables together(product number join), but
> in sql i get in return two lines(I need the date info in
> query) for the same product, but I only need the smallest
> one (20.11.2004).
>
> So i need sum figure, but so, that query shows only the
> smaller date.
>
> Thanks for any help,
> CFI

"CFI" <anonymous@discussions.microsoft.com> wrote in message
news:7ee101c4d123$49c8bf50$a401280a@phx.gbl...
> Hi,
> Your help would be highly appreciated! I have a next kind
> of problem.
>
> I have two tables
>
> A
> B
>
> A table includes some information about production.
> Example product A has been made in two days, so
> information i need is on a two lines and both lines has
> different date information(20.11.2004 and 21.11.2004).
>
> On a table B I have information i need, to be sure that
> the production is ready and the product has been made. Now
> I join A and B tables together(product number join), but
> in sql i get in return two lines(I need the date info in
> query) for the same product, but I only need the smallest
> one (20.11.2004).
>
> So i need sum figure, but so, that query shows only the
> smaller date.
>
> Thanks for any help,
> CFI