Syntax Help w/Column Names

[Overmyhead2]

I have 2 tables:
tblA- Item1
Item2
Item3
Category

tblB- ItemName
Description
Category
I want to SELECT from tblA qty values from the 3 Item Columns & SELECT from tblB ItemName, Description
WHERE tblA.CATEGORY=tblB.CATEGORY
and tblA.Column Names(Item1,Item2,Item3)=tblB.ItemName
First Web Project ..Appreciate any help with this..(-:

Victoria

 

[dbomrrsm]

select countitem1 = count(item1) where tblA.CATEGORY=tblB.CATEGORY
and tblA.Item1=tblB.ItemName,
 countitem2 = count(item2) where tblA.CATEGORY=tblB.CATEGORY
and tblA.Item2=tblB.ItemName,
 countitem3 = count(item3) where tblA.CATEGORY=tblB.CATEGORY
and tblA.Item3=tblB.ItemName

[blue]DBomrrsm[/blue]

 

[hneal98]

  tblA.Item1=tblB.ItemName
or tblA.Item2=tblB.ItemName
or tblA.Item3=tblB.ItemName

 

[dbomrrsm]

sorry forgot to tell it where it was counting:

select countitem1 = count(item1) from tblA where tblA.CATEGORY=tblB.CATEGORY
and tblA.Item1=tblB.ItemName,
 countitem2 = count(item2) from tblA where tblA.CATEGORY=tblB.CATEGORY
and tblA.Item2=tblB.ItemName,
 countitem3 = count(item3) from tblA where tblA.CATEGORY=tblB.CATEGORY
and tblA.Item3=tblB.ItemName

[blue]DBomrrsm[/blue]