Problem in Inner join

See more:

SQL-Server-2005

SQL-Server

I have Two Tables

CREATE TABLE SALES_MASTER
(
	bill_no INT PRIMARY KEY,
	cust_Id INT NULL,
	cust_name VARCHAR(50) NULL,
	total_bill_amount DECIMAL(12,2) NOT NULL
)

CREATE TABLE PAYMENT_DETAILS
(
	bill_no INT PRIMARY KEY,
	pay_mode INT NULL,
	pay_amt DECIMAL(12,2) NOT NULL
)

1 Record In SALES_MASTER:

bill_no  cust_Id  cust_name   total_bill_amount
1000     2424     Deepak      40000

2 Record In PAYMENT_DETAILS:

bill_no  pay_mode pay_amt
1000       C      20000
1000       Q      20000

when i join both tables using

SELECT bill_no,cust_Id,cust_name,total_bill_amount,pay_mode,pay_amt
FROM SALES_MASTER SM,PAYMENT_DETAILS PD
WHERE SM.bill_no = PD.bill_no

I get following Result

bill_no  cust_Id  cust_name   total_bill_amount  pay_mode pay_amt

1000     2424     Deepak      40000              C        20000

1000     2424     Deepak      40000              Q        20000

I want This Result

bill_no  cust_Id  cust_name   total_bill_amount  pay_mode pay_amt

1000     2424     Deepak      40000              C        20000

                                                 Q        20000

Please help me thanks in Advance