select

[Johnny42]

SELECT DISTINCT(item) CONCAT(item,' - ',itemno) FROM ICITEM

can this work ?

 

[r937]

probably not

that's mysql, right? do you realize there is a forum for mysql? see forum436

DISTINCT is not a function

it is a keyword which ensures that only distinct rows are returned by the query

in your case, it will return one row for every distinct combination of item and itemno

rudy

http://r937.com/

SQL Consulting

 

[Johnny42]

using pervasive,

eg:
ID Description
a blah
a blah
c boy
d girl
s dog

result:

a - blah
c - boy
d - girl
s - dog

 

[dnoeth]

SELECT DISTINCT CONCAT(item,' - ',itemno) FROM ICITEM

Dieter

 

[Johnny42]

tried SELECT DISTINCT CONCAT(item,' - ',itemno) FROM ICITEM got this :

ODBC Error: SQLSTATE = 37000, Native error code = 0
Invalid parameter count for scalar function CONCAT.

 

[PHV]

You may try this :
SELECT DISTINCT item || ' - ' || itemno FROM ICITEM

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[r937]

according to the pervasive documentation (and this was the first time i've ever even looked into it), the CONACT function takes two arguments

so i would try

SELECT DISTINCT CONCAT(CONCAT(item,'-'),itemno) ...

rudy

http://r937.com/

SQL Consulting