Re: SQL in 4gl

hashish1@mailcity.com wrote: > > I have two sql statements embedded in the 4gl program, 1(sql1) for fetcing > the data and passing four at a time to the user and 2(sql2) for counting the > whole num of rec. In sql1 im joining 4 tables and selecting 5 common felds so > the record that i obtain appears redundant but if u select all feilds its > actually not, so i use 'select unique' to cut off the rows that appears to be > redundant. The problem comes when i use sql2(select count(*)) statement which > actually counts the 'appears to be redundant records' altogether so i get a > different number. I tried using 'count(distinct [field]) ' but no success, > since i have a composite of fields to be unique. Please help.... > > thank you > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading I think we need more details: the SQL code. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/