CODEWITHSUNDEEP
mysql
Shivesh Jaiswal
Shivesh Jaiswal

Reputation: 117

how to display all fields in mysql join statement if other does not have value

Below script is displaying only that data which they have on both table issuemail and amount. i want that all data should be displayed of table issue mail and amount will become o if that is not in amount table....... cardnumber and barcode are unique in issue table and will not repeat...........on amount cardnumber may repeat but both cardnumber and barcode will not repeate together....... 

Select issuemail.borrowernumber,
  issuemail.cardnumber,
  issuemail.firstname,
  issuemail.surname,
  issuemail.title,
  issuemail.author,
  issuemail.barcode,
  issuemail.issuedate,
  issuemail.date_due,
  amount.amount
From issuemail Inner Join
  amount On amount.cardnumber = issuemail.cardnumber And amount.barcode =
    issuemail.barcode

Upvotes: 0

Views: 72

Answers (1)

user2399866
user2399866

Reputation:

Try using a Left Join instead..Like

    Select issuemail.borrowernumber,
    issuemail.cardnumber,
    issuemail.firstname,
    issuemail.surname,
    issuemail.title,
    issuemail.author,
    issuemail.barcode,
    issuemail.issuedate,
    issuemail.date_due,
    amount.amount
    From issuemail Left Join
    amount On amount.cardnumber = issuemail.cardnumber And amount.barcode =
    issuemail.barcode

Upvotes: 1

Related Questions