hi,
I am having a query to retrieve the item details ,i want only distinct item to be displayed for one user but i am getting more than one item for a single user.please help me
my query syntax is
SELECT distinct member.ibay_user_id as UserName,buy_memberdetail_id,buy_member_id,buy.win_status,Privatelist_ind,member.feedback_score,buy.amount as Amount ,buy.auction_ind as auction_ind,memid.email_id as emailid,member.first_name as first_name ,member.last_name as last_name ,
buy.created_date as create_dt,buy.bid_quantity as bid_quantity, CONVERT(VARCHAR,member.created_dt,109) as StartDate,itemdetail.remove_item_ind ,win_quantity,buy.created_date as bidded_date
FROM tbl_buy_member_detail AS buy
INNER JOIN tbl_member AS member ON buy.buy_member_id=member.member_id
INNER JOIN tbl_address AS memid ON buy.buy_member_id=memid.member_id and (memid.address_type_id = 1 OR memid.address_type_id= 2)
inner join tbl_item as item on item.item_id=buy.item_id
INNER join tbl_item_detail as itemdetail on itemdetail.item_id = item.item_id
WHERE buy.item_id=298 and buy.auction_ind=1 and buy.retract_ind = 0 and buy.cancel_ind=0 and buy.win_status=0 and itemdetail.remove_item_ind=0
ORDER BY buy.amount DESC
|
| Author: Mohammed Shadab 01 Dec 2007 | Member Level: Bronze | Rating:  Points: 2 |
Hi Ram,
I think their is problem in join so it is returningmore then one record for one user, i donot know table structure
From tbl_buy_member_detail AS buy
INNER JOIN tbl_member AS member ON buy.buy_member_id=member.member_id
INNER JOIN tbl_address AS memid ON buy.buy_member_id=memid.member_id and (memid.address_type_id = 1 OR memid.address_type_id= 2)
inner join tbl_item as item on item.item_id=buy.item_id
INNER join tbl_item_detail as itemdetail on itemdetail.item_id = item.item_id
|
| Author: Suba Ganesh 29 Sep 2008 | Member Level: Silver | Rating: Points: 0 |
use distinct Keyword for !using repeated records
|