SIMPLE QUERY HELP - JOINS

[slames]

Hi, I have a query that returns 5 addresses that I want to print labels for. I have a report to do this but I want 3 copies of each address to show on the report.

Is there a way that I can make the address repeat 3 times within the sql, but forcing some sort of multiplying join with a false table or something in sql, or is there something I can do in the report itself?

Any help appreciated.

Thanks

Steph

 

[PHV]

Take a look at UNION ALL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[slames]

Thank You!