I guess it could be both. While some part numbers can fit multiple years, makes, and models of a vehicle others just fit one. The top 200 are our best selling radiators. In theory, i want to hit the master table, pull out all the information on the radiator based on the part number being supplied from the top 200.
Here is a query with all the fields from the Master table, and the Top 200 table has nothing but a part number: SELECT GriffinDataRevised.PartNumber, GriffinDataRevised.Make, GriffinDataRevised.Model, GriffinDataRevised.Year, GriffinDataRevised.Engine, GriffinDataRevised.Edition, GriffinDataRevised.TransCooler, GriffinDataRevised.OilCooler, GriffinDataRevised.HorsePower, GriffinDataRevised.Comments, GriffinDataRevised.Outlets, GriffinDataRevised.TubeSize, GriffinDataRevised.Rows, GriffinDataRevised.CoreSize, GriffinDataRevised.Revision FROM GriffinDataRevised INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.part_number WHERE GriffinDataRevised.PartNumber = Top200.part_number ORDER BY Make DESC Does that help? Thank you so much for bearing with me. On another not, the query that brought back 98 results may have been working right, i found another 78 records in another table for race car radiators, i'm almost guessing that the last few are in another table that would make the total 200 records. But i'm now getting an error that the part_number field is ambiguous. Ugh!!!! Thank you! On Tue, Feb 1, 2011 at 1:47 PM, Ian Skinner <h...@ilsweb.com> wrote: > > On 2/1/2011 10:22 AM, Aaron Renfroe wrote: > > Hello Ian and thank you! > > > > But my query was still running wrong, correct? > > Not necessarily, maybe your data is wrong. You may need to provide some > more description on what data is in each of these tables and how you are > trying to utilize it before we can help much more. > > IS there a ONE TO ONE or a ONE TO MANY relationship between Top200 and > GriffinDataRevised? If ONE TO MANY, do you not want all the record from > the MANY side? IF not all the records, which record of the MANY is the > one that you want? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
