title: SQL - Show Data of Table1(PK) without having data in Table2(FK)
body: <p>there are two tables Customer and Fees <code>(PK customer.CustomerID -&gt; Fees.CustomerId FK)</code>
  there  are customers in <code>Customer</code> table.
  where in table <code>Fees</code> there is no data of current month.
  without inserting data in Fees table of current month
  i want to show the Customer details from Customer table of whom have not paid the fees of current month.</p>
  
  <p>something like:</p>
  
  <pre><code>if(Convert(varchar(3),MonthFee, 109) != convert(varchar(3),getdate(),109))
  BEGIN
  select Customer.CustomerId as ID, Customer.CustomerName as Name, Customer.Phone as [Phone No], 'UnPaid' as [Pay Status], convert(varchar(3),getdate(),109) as [Month], YEAR(GETDATE()) as [Year]
  from Customer inner join Fees on Customer.CustomerId = Fees.CustomerId Where FeeMonth = null
  
  END
  </code></pre>
  
  <p>Help will be appreciated, thanks.</p>