I have the folloowing list
orderfrom |Name
---------------
ClearVision, Oakley, I-Deal Optics | ClearVision
ClearVision, Oakley, I-Deal Optics |I-Deal Optics
ClearVision, Oakley, I-Deal Optics |Oakley
I want a querry that doesnt show these if name is in orderfrom
example:
orderfrom |Name
---------------
ClearVision, Oakley, I-Deal Optics | ClearVision(Would NOT return this record)
ClearVision, |I-Deal Optics(Would return this record)
ClearVision, , |Oakley(Would return this record)
I Tried the following! whats important is the very last part please over luck anything else you see as to its working!
SELECT * FROM `dist` JOIN `patientacct` ON `patientacct`.dist LIKE CONCAT('%', `dist`.name ,'%')
inner join `treasure` on `treasure`.`id` = `patientacct`.`id` where (status = 'To Order' and
This part is where I need help!(( `dist`.name not like CONCAT('%',`patientacct`.orderfrom,'%')) ))
order by `name` ASC
IN need of help thanks to all!
Going to eat will reply when i return if i get a helpful samaritan!