Grid with categories


2006-02-04 03:02:17 AM
cppbuilder113
I need a grid with this format:
Item1 cat 1 | picture category 1 |
Item 2 cat 1 | |
----------------------------------------
Item1 cat 2 | picture category 2 |
Item 2 cat 2 | |
<blank>| |
----------------------------------------
Item1 cat 1 | picture category 2 |
| |
| |
----------------------------------------
I have two tables, one with IDItem, Name and IDCategory and other with
IDCategory, Name and Picture.
I Dont Know how to make it with the TDataGrid control and wich SQL statement
I have to use.
Please forgive my very poor English.
If anyone can help me...
Thanks.