0
I use Visual Basic 2008
     Database is Mysql


         Three tables:

         1. table article
              fields: item number, item description, color number, month number
                   100        chair       2            3
         2. table colors
              fields: color number, color description
                             1 red
                             2 blue



     3. table months
     fields: month number, month description
                   1 January
                   2 February
                   3 March

     I want a relationship between article and table table table colors and months.
     I want to see in the datagridview :
     item number, item description, color , month 
         100       chair           ,blue  ,  March

How do I do this in Visual Basic 2008

Thanks,

Andre

Edited by dre-logics

2
Contributors
2
Replies
4
Views
5 Years
Discussion Span
Last Post by dre-logics
0
select a.item_number, a.itemdesc,c.colordescription,m.monthdescription from article a, colors c , month m where a.colornumber=c.colornumber and a.monthnumber=m.monthnumber
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.