How to select top value using two table
i Have two table
table1:itemTbale
table2:itemDetails
itemTable contain
id | itemName
itemDetails
id | itemID | price | details
table may contain data like this
id | itemName
1 Vechile
2 Fruits
id | itemID | price | details
1 1 80$ bla bla
2 1 150$ bla bla bla
3 1 200$ bla bla
4 2 5$ ..
5 2 8$ ..bla
6 2 7$ bla..
Now i have to select top item details for each itemID
LIKE
id | itemID | price | details |itemName
1 1 80$ bla bla Vechile
4 2 5$ .. Fruits.
I am being little confuse with query.Help me Thank you in advance.
No comments:
Post a Comment