You've to join two tables

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

>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!