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

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

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

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

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