SQL and Distinct

Distinct applies to an entire query, and not just one field.  So, you'd want to use the following to select distinct.  I also added some parens in your where clause, otherwise your or statements will just "take over" and your other statements wont really matter :)

Also, DISTINCT is sometimes "costly", you might want to look into using GROUP BY instead when possible.

select distinct vehicle_additional_information.trim
  from ebizcardata
 inner join vehicle_additional_information
    on ebizcardata.Stock_No = Vehicle_Additional_Information.Stock_No
 where (Modell = 'Accord' 
   and New_Used = 'New' 
   and Ext_Color = 'Taffeta White')
    or (Modell ='Accord'
   AND New_Used = 'New' 
   AND Ext_Color = 'White Diamond Pearl')
 ORDER BY Year ASC,  STR_TO_DATE(Date_In_Stock, '%m/%d/%Y') ASC

Select allOpen in new window

Am I not asking the question right? Both of your examples work (well kind of) but not still do not give me what I am looking for. I need all the data from both the tables (I use it later in the code) but I do not want to show the duplicated trim column results.  

Thanks again for the help.

I believe what you want is the TOP opeerator not Distinct.  The first query below will give you just the first row that match your criteria, but all columns from both tables.
If it is that you only want the top 1 row from the Vehicle_Additional_Information table and all the values from the other table, ebizcardata, then you will have to the query something like the second example where you make the Vehicle_Additional_Information into a subselect that uses TOP 1 to get the first record from there and match it to the other table.

$query_CRV = "SELECT TOP 1 * " .
"FROM ebizcardata " .
"INNER JOIN Vehicle_Additional_Information " .
"ON ebizcardata.Stock_No = Vehicle_Additional_Information.Stock_No " 
"WHERE Modell = 'Accord' AND New_Used = 'New' AND Ext_Color = 'Taffeta White' 
OR Modell ='Accord' AND New_Used = 'New' AND Ext_Color = 'White Diamond Pearl'" .  
"ORDER BY Year ASC,  STR_TO_DATE(Date_In_Stock, '%m/%d/%Y') ASC";
 
$query_CRV = "SELECT * " .
"FROM ebizcardata " .
"INNER JOIN (SELECT TOP 1 * FROM Vehicle_Additional_Information ".
"    WHERE conditions_that_limit_this_table=values) Vehicle_Additional_Information " .
"ON ebizcardata.Stock_No = Vehicle_Additional_Information.Stock_No " 
"WHERE Modell = 'Accord' AND New_Used = 'New' AND Ext_Color = 'Taffeta White' 
OR Modell ='Accord' AND New_Used = 'New' AND Ext_Color = 'White Diamond Pearl'" .  
"ORDER BY Year ASC,  STR_TO_DATE(Date_In_Stock, '%m/%d/%Y') ASC";

Select allOpen in new window

i think you need this.

SELECT e.*, v1.Trim 
  FROM ebizcardata e
 INNER JOIN Vehicle_Additional_Information v1 
    ON e.Stock_No = v1.Stock_No 
 INNER JOIN (SELECT Stock_No,MAX(Trim) AS Trim FROM Vehicle_Additional_Information GROUP BY Stock_No) AS v2
    ON v1.Stock_No = v2.Stock_No AND v1.Trim = v2.Trim
 WHERE Modell = 'Accord' AND New_Used = 'New' 
   AND Ext_Color IN ('White Diamond Pearl','Taffeta White')
 ORDER BY Year ASC,  STR_TO_DATE(Date_In_Stock, '%m/%d/%Y') ASC

Select allOpen in new window

Well thanks for your efforts. It still does not do what I was attempting to do but I did learn some ways to clean up the initial statement.  So I'll close this question.

The problem still exist. Duplicate trims are returned.

Thanks any way.

I can't figure out how to split up the points and you IN clause was the most helpful tip I learned by asking this question even though my original problem still exists.

If you still need assistance, post the result of my query and your expected result.