D
Dustin Swartz
I have two colums in my "Select Distinct" query and they are working, Now
how do I bring along the non distinct information in these rows?
Obviously if I add the non distinct columns into my statement it changes the
select results
This is my current SQL statement
SELECT DISTINCT OsPos.PosNr, OsPos.Bez
FROM OsObj INNER JOIN OsPos ON OsObj.ObjNr = OsPos.ObjNr;
It brings in the correct records but only from OsPos.PosNr, OsPos.Bez
I want to say (I don't know SQL)
SELECT
OsPos.Obsum, OsPos.PosNr, OsPos.Bez
Where OsPos.PosNr, OsPos.Bez ARE a DISTINCT combination
Ideas?
how do I bring along the non distinct information in these rows?
Obviously if I add the non distinct columns into my statement it changes the
select results
This is my current SQL statement
SELECT DISTINCT OsPos.PosNr, OsPos.Bez
FROM OsObj INNER JOIN OsPos ON OsObj.ObjNr = OsPos.ObjNr;
It brings in the correct records but only from OsPos.PosNr, OsPos.Bez
I want to say (I don't know SQL)
SELECT
OsPos.Obsum, OsPos.PosNr, OsPos.Bez
Where OsPos.PosNr, OsPos.Bez ARE a DISTINCT combination
Ideas?