query

[tazgalsinh]

this is my query for my catalog:

SELECT *
FROM item, Manfac
WHERE item.ManID = Manfac.ManID
ORDER BY item.typeID

in the item table there is a typeID field. this field corepondes to a manfac table and in the table is the fields typeID and typeNAME. So in the item table, items with 2 as the typeID are software and 3 are tv's etc etc.

how am i able to pull of the typeNAME field staright into the catalog. so in my catalog list i have the correct typeNAME. can i one help please?

[tomhath]

I don't understand what's giving you trouble. DOesn't this give what you want?

SELECT item.typeID, item.typeName 
FROM item, Manfac 
WHERE item.ManID = Manfac.ManID 
ORDER BY item.typeID 

[mystrymaster]

yeah simply adding that field should give you what you want if it is the output that is giving you trouble then that is a different story