Selecting distinct rows?

Distinct doesn't work on a single field, it works on the entire row. Your result contains only the distinct rows, i.e. Only rows where all fields are the same are removed If you want distinct values for a specific field, you can use group by : select table1.

MyID, min(table1. TypeID) as TypeId from ... group by table1. MyID This will give you a result with distinct values for myID but for the fields that you are not grouping on you should specify which value to get.

For this you use aggregates like min and max MySQL might allow you specify fields without aggregates, but then it will just pick the first value that comes up (which might not at all be what you think would be the first value).

Distinct doesn't work on a single field, it works on the entire row. Your result contains only the distinct rows, i.e. Only rows where all fields are the same are removed.

If you want distinct values for a specific field, you can use group by: select table1. MyID, min(table1. TypeID) as TypeId from ... group by table1.

MyID This will give you a result with distinct values for myID, but for the fields that you are not grouping on you should specify which value to get. For this you use aggregates like min and max. MySQL might allow you specify fields without aggregates, but then it will just pick the first value that comes up (which might not at all be what you think would be the first value).

One way to do what you seem to want is: SELECT Distinct 'myID' as IDType, `table1`. `myID` AS ID UNION SELECT DISTINCT 'TypeID' as IDType, `table1`. `TypeID` AS `ID` This will give you unique values for each column as follows: myID 1 myID 2 myID 3 TypeID 101 TypeID 201 TypeID 301 You won't know which values go together, but you will know which values show up in each column.

You cannot use distinct on a column only rows. You can accomplish what you are trying to do by using subquery.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.