Guest_imported
New member
- Jan 1, 1970
- 0
My SQL query:
SELECT Num,
Dis_code
FROM DefCodes
WHERE (((Num)=123456) AND
((Cancel_date) Is Null))
Produces this:
123456 006
123456 014
123456 022
Can the following display be accomlished in SQL?
123456 006, 014, 022
SELECT Num,
Dis_code
FROM DefCodes
WHERE (((Num)=123456) AND
((Cancel_date) Is Null))
Produces this:
123456 006
123456 014
123456 022
Can the following display be accomlished in SQL?
123456 006, 014, 022