SQL problem

 
Hi Everyone,
Can you please re-write my SQL statement so that it will work faster:
Thanks,
May
SqlDataAdapter myCommand = new SqlDataAdapter("SELECT [display_value], [main_category_1], [product_list_image], [item_number], [item_product_description], [item_size], [item_whole_sale_price], [item_sale_price], [display_item_sale_price] " + "FROM NEW_MAIN_CATEGORY_1_table_English, PRODUCT_table_for_each_brand_English WHERE NEW_MAIN_CATEGORY_1_table_English.product_sku = PRODUCT_table_for_each_brand_English.product_sku AND PRODUCT_table_for_each_brand_English.active='yes'", con);
...