troubleshooting Question

MySQL inner join only if record exists

Avatar of Lmillard
Lmillard asked on
DatabasesMySQL ServerSQL
6 Comments2 Solutions678 ViewsLast Modified:
Hi,

I have a query which is selecting tasks and inner joining to a customer table. I have now amended the application so that you can create a task without it being allocated to a customer. At the moment the join query will only return the record if the tasks.cid field is populated.
Can anyone suggest the best way to allow it to retrieve all tasks even if the cid field is null and if it is populated retrieve the customer details?

Regards
Leigh
SELECT 
        Tasks.TaskId, 
        Tasks.cId, 
        Tasks.TaskDet, 
        Tasks.startDate,
        Tasks.UsrId, 
        WEEK(startDate) AS thisWeek,
        Customer.Company 
        FROM tasks 
        INNER JOIN Customer 
        ON tasks.cid = Customer.cid
ASKER CERTIFIED SOLUTION
enachemc

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros