Data represantation in SQL table

[CrystalReport]

I have a table with a unique field having multiple records
like
date InwardCode
23/9/00 001
23/9/00 002
23/9/00 003
now I want to represent this data as follos
date InwardCode
23/9/00 001
002
003
what the SQL Query would be
please help me out! [sig][/sig]

 

[foxdev]

...I want to represent this data...

The key here is in your question: you cannot select the data from the server in the format you've specified; instead, you'll need to use your client software (Access, VB, HTML, whatever) to present the data in the way you want. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]