Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ts568
  • Order by date
  1. ts568

    a query to count the frequency of an occurence

    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...
  2. ts568

    Small problem with query

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

    How do you pickup null (or empty) data fields in a sql query?

    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.*...
  4. ts568

    Small problem with query

    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.
  5. ts568

    Small problem with query

    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...
  6. ts568

    Difficult query need help

    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'
  7. ts568

    Difficult query need help

    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...
  8. ts568

    Query problem for getting ages of users

    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
  9. ts568

    Query problem for getting ages of users

    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.
  10. ts568

    Query problem for getting ages of users

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

    Query problem for getting ages of users

    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.
  12. ts568

    Query problem for getting ages of users

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

    Query problem for getting ages of users

    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...
  14. ts568

    Query problem for getting ages of users

    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...

Part and Inventory Search

Back
Top