SQLish

[whwar9739]

I was curious if anyone could give me a better way of doing something similar to the following only without using an SQL statement.

select distinct (some fields)
   from table1
   join table2
   join table3
   group by (some fields).

My issue is that one of the tables happens to be a temp-table and the SQL supported statements in 4GL can not utilize temp-tables.

Thanks in advance for any help.

 

[tamhas]

Look up BREAK-BY and FIRST-OF

 

[whwar9739]

Thank you,

I ended up with a total 'DUH!!!' moment there.

 

[Casper]

anyhow, sql statements in the 4GL are deprecated and IMO should not be used.

Casper.