Adding fields to existing select distinct statement 
Author Message
 Adding fields to existing select distinct statement

I have a select statement with DISTINCT

select distinct somast.partnbr, somast.discription
soitem.fenumber
from somast
join soitem ...????????

I just want to a field next to soitem.fenumber and that is Character field.

Can someone please help.

Thanks.



Tue, 03 Jan 2006 23:56:11 GMT  
 Adding fields to existing select distinct statement
Hello, mac!
You wrote  on Fri, 18 Jul 2003 15:56:11 GMT:

 m> select distinct somast.partnbr, somast.discription
 m> soitem.fenumber
 m> from somast
 m> join soitem ...????????

 m> I just want to a field next to soitem.fenumber and that is Character
 m> field.

SELECT DISTINCT somast.partnbr, somast.discription, ;
        fenumber, SPACE(10) AS chrfield ;
FROM ....
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8



Wed, 04 Jan 2006 00:51:24 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Adding a field with a select statement

2. adding memo field to result of Select statement

3. "select distinct" and memo fields

4. VFP8 - SELECT DISTINCT SQL nolonger supports memo fields

5. "select distinct" with memo fields

6. adding existing forms to an existing formset

7. adding zeros to existing field

8. adding existing forms to an existing formset

9. Two DISTINCT statements ??

10. VB select distinct Fax, Co_nam from tableA doesn't

11. FPW 2.6 Select distinct problem

12. VFP 5 Select Distinct Records

 

 
Powered by phpBB® Forum Software