Kodo can you check this SQL for me

OK I finally am back working on this program. So check out this joint statement.

Code:

SELECT CUST.ID, CUST.FNAME, CUST.LNAME FROM CUST, PUR_HST WHERE
CUST.ID = PUR_HST.ID AND PUR_HST.ID AND PUR_HST.FDATE BETWEEN CALENDAR1.VALUE AND CALENDAR2.VALUE AND PUR_HST.TYPE = 'F';

Everything Legal there? if that works that will take a lot of work out and I can just write that to an array and print it. What do you think?

 

doesn't look valid to me.

try this one
Select cust.id, cust.fname,cust.lname from cust inner join pur_hst.id on cust.id=pur_hst.id where pur_hst.date between calendar1.value and calendar2.value and pur_hst.type='F';

 

thnaks will do


sucks having to program all this with no way to test until I can get onsite