Hi to all,
I have two table one is product table with attribute P_ID,P_Name and second table is order_detail with attribute O_ID,P_ID P_ID here is foreign key from product table
Now i want to get the product name from product table who has more product in order_detail table for example
query should return
Product name ABC from product table has 3 records in order detail at the top then product name XYZ b/c this has two rows in order detail table and then product name DEF.