Good morning,
I'm running the latest build of R:BASE X Enterprise. I have a connection to a SQL database & about 6 or 8 SQL tables attached. I'm trying to create a SQL Select Distinct statement and can't get the syntax correct. Here's what I've tried: SELECT DISTINCT dbo.sales_rep.id AS rep_id, sales_rep.NAME-ALIAS from dbo.SALES_REP Error is: SELECT DISTINCT sales_rep.id AS rep_id from dbo.SALES_REP Error is: But this works without error: SELECT * from dbo.SALES_REP Any blues clues? Thanks, Paul Buckley -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
