Hello y'all...

So I am trying to figure out a query using a Left Outer Join.

I have 2 tables, tblService and tblCustomerService. What I need is for all services from the tblservice table to be displayed but I only want a 'customprice' from the tblcustomerservice table to appear where one is set.

So this is what I have:

SELECT 
(IF s.IsPart = 1 THEN 'Part' ELSE 'Service' ENDIF) as Category, s.code,s.price,c.customprice,
s.Description, c.pfp, (IF s.IsTaxable = 1 THEN 'X' ELSE '' ENDIF) 
as 
IsTaxable,  
 s.IsActive, 'NotEmpty', s.id
FROM tblService s LEFT OUTER JOIN tblcustomerservice c on s.id = c.serviceidPrice

What I need to do is only show 'PFP' and 'CustomPrice' where customerID = "somevalue"

For Clarity: I want all services to show up but only PFP and Custom price for those where a certain customerid is specified. How do I form this Order by or the WHERE clause.

Thanks in advance for the help!

-Nick

BTW...

the customerid field is in the tblcustomerservice table.

Thanx

So you want all qualifying rows to show up, but customprice and PFP are blank unless customerid matches? If so, that is not in ORDER BY or WHERE, but in the actual row selection.


If I understand you correctly, you have:
... c.pfp, ...

And you want:
... (IF customerid=$x THEN c.pfp ELSE '' ENDIF), ...