SQL query correctness/efficiency of my query

Is this the correct way to join 3 tables and if so is there another more
efficient way to do it.
The 3 tables item_master,cost_item,item_comments have the common key item_no
which is the
pk in item master and the foreign key in the other 2.
It seems to work and I am checking the data for errors but there are
thousands of rows and it is slow going. I am using Oracle 9i.
Thanks Rob

select item_master.item_no,
item_comments.comment_text,
item_master.qty_on_hand,
cost_item.unit_cost,
item_master.status_flag
from item_master,cost_item,item_comments
where cost_item.item_no = item_master.item_no
and item_comments.item_no = item_master.item_no
and status_flag = 'A';



.

Relevant Pages

  • Highlighted programs
    ... in this way and is it possible to change this so all listed programs appear ... with the normal white background. ... Rob. ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • merge multiple files from text list of file pairs
    ... Rob ... rroach's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21093 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Dumb Question regarding Indexes
    ... >> The usual policy ought to be that all foreign key columns are indexed. ... >> Sybrand Bakker, Senior Oracle DBA ... And in DB2 this may not be an issue, however with Oracle unindexed ... if you read the above link you'll see the expense of NOT indexing ...
    (comp.databases.oracle.server)
  • If Statement problem
    ... My test code only gives a message box saying 1st January 2005 not feb march ... Here is my sheet ... Rob ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Having a macro recognize when an option button has been selected
    ... button will already have it's radio button showing as being selected) and ... will then execute code specific to which button it finds as being last ... Rob ... Prev by Date: ...
    (microsoft.public.excel.programming)