>i have two table
>
>(table invoice) = inv_no,trans_no,client_code,client_name
>
>and
>
>(table item_invoice) = inv_no,trans_no,item_hscode
>
>so i want to retrieve all the client name that have the item_hscode 8899009900
>
>so how can i do thatSomething like this:
select aa.inv_no,aa.trans_no,aa.client_code,aa.client_name ;
from invoice aa ;
join item_invoice bb ;
on aa.inv_no = bb.inv_no ;
where bb.item_hscode = 8899009900 ;
into cursor MyResults