Mysql problem
Posted: Tue Mar 30, 2004 4:07 pm
I am trying to run a join based on a where condition but something seems to be wrong with the way I am writing the query. The query is as under
SELECT * FROM sitemaster,usitemaster where sitemaster.siteno=usitemaster.siteno and sitemaster.branch='078' or sitemaster.branch='079' or sitemaster.branch='083' order by cname
I need to be able to use multiple OR's and thats what creates the problem.
SELECT * FROM sitemaster,usitemaster where sitemaster.siteno=usitemaster.siteno and sitemaster.branch='078' or sitemaster.branch='079' or sitemaster.branch='083' order by cname
I need to be able to use multiple OR's and thats what creates the problem.