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.
Mysql problem
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England