I think changing MAX to MIN and adding a GROUP BY clause may help you get there, but "James" is still going to be at that top of the list for ID 100:

SELECT Table1.id, Table1.vname, MIN(Table2.name);
  FROM Table1 INNER JOIN Table2 ;
    ON Table1.id = Table2.id ;
  GROUP BY 1 

To fix that, you can change MIN(Table2.name) to MIN(LOWER(Table2.name))

>I am trying to get the last value entered as a character in a table using max command: Here is what my test data looks like
>

>table1:
>id   vname
>============
>100 veh1
>200 veh2

>
>

table2:
>id   name
>=============
>100 "James"
>200 "tammy"
>100 "john"
>100 "cindi"
>200 "angie"

>
>I am trying to get max value from table2 "name" column for each vname in table1 using sql statement. Here is the statement that I did but it didn't produce right results.
>
>

SELECT Table1.id. Table1.vname,  max(Table2.name);
> FROM  fleet!table1 INNER JOIN fleet!table2 ;
>   ON  Table1.id = Table2.id

>
>
>I need the results to be
>
>

>100  veh1  "cindi"
>200  veh2  "angie"

>
>I'm I doing the max wrong on characters? What is the correct way to do it.
>
>Thanks
>Nick Patel