[SOLVED] Database query (outputting result [multiple tables])

[Lang]

This is in regards to VB6 - I currently have connected to my database and succesfully ran a query. When one table is involved in the query, I can output the data. But when there's two tables I cannot.

            ss1.Row = 1
            ss1.Col = 1
            ss1.Text = gMySet!FOOD_DES.Desc
            ss1.Col = ss1.Col + 1
            ss1.Text = gMySet!ABBREV.Water

Table 1: FOOD_DES
Table 2: ABBREV

Any help is appreciated.

[sagarpassion]

Can u please tell wat query u have passed?? Is it joins??

[Lang]

It doesn't matter. I've done it.

Thanks for the help.