Hi! I have a problem. I have a table that is related to another table. Table 1 has 77,000 records and the table 2 has 25,000. I use a SQL statement to bring the corresponding data to a cursor. However, when it does not find the correct conditions, it brings over all the data, but does not show it. Can someone help me? I get a cursor with 77,000 records in it. Yikes!!

SELECT * ;	
FROM order_items ;
	WHERE inv_no = order_file.inv_no AND prn_order = 8 ;
		INTO CURSOR cur_sql_result

Oh yeah, using VF6

Thanks for any help!