title: mysql full join query
body: <p>What's wrong with the following query. It's not working and I basically need it to do a full join and return all fields whether there is a match or not.</p>
  
  <pre><code>SELECT tbl_tickets.ID AS Ticket_ID, tbl_tickets.Ticket_Number, tbl_tickets.Ticket_Category, tbl_orders.PO_Number, tbl_invoice_to.Name AS Dealer_Name 
  FROM tbl_tickets 
  FULL INNER JOIN tbl_orders ON tbl_tickets.Order_ID=tbl_orders.ID 
  FULL INNER JOIN tbl_invoice_to ON tbl_tickets.Invoice_To=tbl_invoice_to.ID
  WHERE Ticket_Type='PARENT' AND {$where} 
  ORDER BY tbl_tickets.Ticket_Category
  </code></pre>