hector lobo
Jan 27th, 2000, 11:34 AM
I have a problem with crystal report regarding sub query how to write this query in VB 6.0 the qurey is
select * from cust,calls where cust.customerid = calls.customerid and callid in (select max(callid) from calls where customerid = text1.text)
thanks & regards
hector lobo
select * from cust,calls where cust.customerid = calls.customerid and callid in (select max(callid) from calls where customerid = text1.text)
thanks & regards
hector lobo