subqueries again

[Philippe DAVID <Philippe.DAVID@GLENAT.COM>]

My precedent message has been rejected, so I try again

Hello folks !
I have a problem: i'm trying to understand how Visual Sqribe works.
        I want to use subqueries to find some infos related with the datas I
retrieve from database but I don't understand how it work.
        Where are displayed the infos of the subqueries ?

        I have to display a company name, a product family, a product name.
        I extract from a first table the references ( number code) of the 3
items, and then I want to extract the name of each item from an other table
where I can find three columns, one where I find the entire name, one with
the same number code as upon, and one with a code which indicate the type of
data concerned by the code (company,family,product...)
If I was working with SQR, I think I should make a procedure where I search
in the second table but how to do that with Visual Sqribe.

        An other question: does the .lis files still exist with visual ?

Philippe DAVID
  Editions GLENAT
  6 rue Lt Chanaron
  38000 GRENOBLE
  33 (0)4 76 88 75 92