shaggydoink
Last Activity: Jul 26 '08, 06:55 PM
Joined: Jul 24 '08
Location:
-
p.s: works perfectly! Thanks again for your help on this.... -
I can't thank you enough Delerna! I haven't quite figured out WHY this works - that is to say, the SELECT draws the LNProdClassName field and I thought the only way to do this would be to include the LNProdClass table in the FROM - for example:
select MapID, LNProdClassName as Product
from CompMap, LNProdClass
etc...
But I will give this a shot a post if I have any issues. Thanks again!...Leave a comment:
-
Thanks so much for the quick reply CK.
***************
Here are some SELECTS and sample data - the first is the table that is designed to build the final output/matrix
***************
select * from
CompMap
WHERE MapID = 1
MapID LNProdID TypeID SupLevelID TPProID
----------- ----------- ----------- ----------- -----------
1 5 2 ...Leave a comment:
-
Query Across Multiple Tables
I've interacted with SQL DBs for years in project/product management roles, although admittedly still a newbie when it comes to actually building and manipulating things within SQL directly. I've inherited a project and have spent hours trying to figure something by browsing through user docs and other posts and trying things but am still stumped - hence me calling in the experts! :)
What I am trying to finish building seemed like...
No activity results to display
Leave a comment: