Search results for query: *

Is there a way of writing a query that looks at a table and works out from staffNumber, which staff members number appears most on the table and then links back to the STAFF table and shows their name? So there are two tables ORDERSPROCESSED and STAFF And I want to view which staff member has...

Thanks for your help guys, I have sloved this problem now

I have an entity which I would like to create a query which will look into the entity and give me all of the orders which have not got a staff member assigned to them. I have done the query the way I believe it needs to be, however a blank table is showing up when it is executed. SELECT ORDER.*...

Thanks for your help, I have used your first example and have now got SELECT CUSTOMER.*, ORDERS.* FROM CUSTOMER, ORDERS WHERE Not CUSTOMER.Paid AND ORDERS. orderDate BETWEEN "01/05/2007" AND "31/05/2007"; Its very close now but it wont execute ever since I have put in the part about the date.

Hello, I want to make a query which will list all customers who have ordered something on a specific date but who have not paid yet) This is what I have got so far SELECT CUSTOMER.*, ORDERS.* FROM CUSTOMER, ORDERS WHERE (((CUSTOMER.customerNumber)= 'paid.yes')); I am unsure of what to do...

Thanks for the reply, Would your idea still work if my date format is day/month/year? e.g. today = 09/05/2007 Or would I have to enter in '01' as opposed to '1'

Hello, this time, I have an entity called SUPPLIERSHIP there are 3 tables/attributes: dateCanBeShipped supplierName and productType I need to make a query that allows me to enter in a month, either into the query, or even better, a box pops up for me to enter it in. When I have entered in...

jimirvine, thanks for that, thats a very good idea. I will have a go at trying this soon, I must move on for now, as I have many other queries I want to get through. Thanks again for your input! I will let you know how it goes. JerryKlmns, I would love to be a mySQL fan!!! hehe

Thanks JerryKlmns, I understand what you mean now, and thanks Leslie, I missed your original post. Your help has been super, thanks for all of those examples they have really helped me understand whats going on. Thanks again.

Thanks for the reply, It works well, I understand everything apart from: UNION SELECT 'M', 'Total :', COUNT(*) could you explain what UNION does?

An example would be, Number of Customers 20-25 years old (field name) 3 (value) If this is possible? I could maybe do it as a seperate query from the one above.

Also, the other problem, is that I need to return the number of customers in this age group too.

Thanks for that, it worked a treat, the only thing that is happening, is the title, firstName and lastName are all bunched into one, So say I had Mr Joe Bloggs, I am getting MrJoeBloggs. Is there any way to stop this? I tried putting in " " between SELECT [title] & [firstName] & [lastName] AS...

Hi, I need to try and write query which goes into my CUSTOMER table, and returns the number of male customers between the ages of 20 and 25. The only thing in the CUSTOMER table which could help is DOB which is in the format 23/04/1975 There is also a field called Gender where you can either...