> I have four (4) tables. One table holds IDs that reference info in the
> other three (3) tables by ID. I am trying to pull the information for an
> item, and pull the info specific to that item from the three tables.
> What's wrong with this picture?
>
> select i.intBoutItemID as ID,
> c.txtBoutCat as Cat,
> s.txtBoutSubCat as SubCat,
> d.txtDesignName as Name,
> i.blActive as Active
> from tblBoutItem i,
> tblBoutCat c,
> tblBoutSubCat s,
> tblBoutDesign d
> where c.intBoutCatID = i.intBoutCatID
> and s.intBoutSubCatID = i.intBoutSubCatID
> and d.intBoutDesignID = i.intBoutDesignID
> Order by d.txtDesignName
Nothing: http://developer.mimer.com/validator/parser99/index.tml
So why don't you tell us what is wrong?
Jochem
--
When you don't want to be surprised by the revolution
organize one yourself
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
