如何加入两个表我

Question

我要加入两个表完全

productbill 
BillID | TransactionID 
1  | 12344 
2  | 34353 

viewproduct 
sno|BillID|Productname|Rate|Quantity|Amount 
1 |1  |xyz  |12 |2  |24 

required output 
    BillID|TransactionID|Productname|Rate|Quantity|Amount 
    1 | 12344  |xyz  |12 |2  |24 

我的查询是：

$joinview=mysql_query("select viewproduct.BillID,productbill.TransactionID,viewproduct.Productname,viewproduct.Rate,viewproduct.Quantity,viewproduct.Amount from viewproduct FULL OUTER JOIN productbill ON productbill.BillID=viewproduct.BillID"); 

请帮我在这

Answer 1

SQL内连接的你需要什么！

SQL INNER JOIN

查看示例代码和演示数据库。

SELECT productbill.BillID, productbill.TransactionID, viewproduct.Productname, viewproduct.Rate, viewproduct.Quantity, viewproduct.Amount 
FROM productbill 
INNER JOIN viewproduct ON productbill.BillID = viewproduct.BillID; 

Answer 2

正如Maasoud建议的那样，您需要Inner Join。

查询将

$joinview=mysql_query("SELECT productbill.billId as billId, productbill.TransactionID as TransactionID ,viewproduct.Productname as Productname, viewproduct.Rate as Rate, viewproduct.Quantity as Quantity, viewproduct.Amount as Amount FROM productbill AS productbill INNER JOIN viewproduct as viewproduct ON viewproduct.BillID = productbill.BillID");