sandy1028 Posted September 12, 2007 Share Posted September 12, 2007 Hi, Please help me how to write the query. To fetch the different category of jobs(running,queued and completed) for the particular centre of the city. For each city there are different centres. The data should be displayed in this format CentreNames--------------------------- CityNames Running Queued Completed . . . Quote Link to comment Share on other sites More sharing options...
pocobueno1388 Posted September 12, 2007 Share Posted September 12, 2007 Can you give us more information on your database setup? List the tables and what fields they have. Quote Link to comment Share on other sites More sharing options...
sandy1028 Posted September 13, 2007 Author Share Posted September 13, 2007 hi, Table contains city, centres,state. State is the type of jobs. It contains the fields R,W,P depending on state running,waiting or completed. How to write the query for paticular city and centres depending on the state the value should be filled in respective columns of R W P Please tell me how to proceed Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.