Good Morning Everyone! I'm having a mental issue on how i can get the data i need based on a part number that Iâm retrieving from one table. In the one table i have the top 200 sellers, in my other three tables i have all of the information that goes with the parts.
I have written three queries that go to each of the three tables. Question 1: In all the tables the part number may fit 7 different applications, therefore the part number can be in there multiple times on my results. I have used the "DISTINCT" attribute to get the distinct number from the table that hosts the information. How can i pull all of the corresponding info (Year, Make, Model, etc) while Iâm using the distinct clause? Question 2: If i wanted to get all information from any of the three tables based on a single part number without duplicates, how would i write that. I'm not sure is i should be doing joins, or sub-queries, and/or unions. Here are my 3 queries: <cfquery name="get_Main_Group_rev" datasource="XXXXXXX" username="XXXXXXX" password="XXXXXX"> SELECT DISTINCT PartNumber FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number WHERE Top200.part_number = GriffinDataRevised.PartNumber </cfquery> <cfquery name="get_Main_Group_dominator" datasource="XXXXXXX" username="XXXXXXX" password="XXXXXXX"> SELECT DISTINCT Dominator.part_number FROM Dominator INNER JOIN Top200 ON Top200.part_number = Dominator.part_number ORDER BY Dominator.Part_Number ASC </cfquery> <cfquery name="get_Main_Group_race" datasource="XXXXXXX" username="XXXXXXX" password="XXXXXXX"> SELECT DISTINCT PartNumber FROM GriffinRaceDataNew INNER JOIN Top200 ON GriffinRaceDataNew.PartNumber = Top200.Part_Number WHERE Top200.part_number = GriffinRaceDataNew.PartNumber </cfquery> How can i simplify this process :) Thank you! Aaron ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm