Finding Last record in another table

[JohnG1234]

I am new to SQL and just started making reports in reporting services, need help on how to write a query in SSRS 2005 dataset

Here is an example

Table A (3 columns Date , Limit, Product)

Date Limit Product

4/1 10 A

4/1 5 B

4/4 8 A

4/5 15 A

4/6 10 B



Table B
(All shop Dates)


4/1

4/2

4/3

4/4



and I just want these 3 columns



Date Limit Product

4/1 10 A

4/1 5 B

4/2 10 A

4/2 5 B

4/3 10 A

4/3 5 B

4/4 8 A

4/4 5 B

4/5 15 A

4/5 5 B

4/6 15 A

4/6 10 B



I really appreciate your help, Thanks

[ronverdonk]

Welcome to Bytes!

I can in no way understand what your problem is. What type of SQL query are you looking for? And what are the relations between these two tables? And how do you use these relationss? Please explain your problem or question a bit more elaborate.

See also the chapter "how to ask a question" in the Posting Guidelines

Ronald