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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
