Search results

Hello everybody, I am unsure whether this is best done in SQL or VBA, however, I do believe it is possible in SQL so I will put it here. I have a field 'value of purchase' in which an items cost is inserted. What I am wanting to do initially is automatically deduct 20% off the value of...

I am wanting to display the heighest tree giving the name of the tree, its height, which supplier supplies it including the suppliers name and address. I know I need a MAX in there somewhere, however, this shows what I want: SELECT PLANTEN.PLANTNAAM, PLANTEN.SOORT, PLANTEN.HOOGTE...

Hi, I am trying to show the supplier which sells all species of plants: SELECT LEVERANC.LEV_NAAM, PLANTEN.SOORT FROM PLANTEN INNER JOIN (LEVERANC INNER JOIN OFFERTES ON LEVERANC.LEV_CODE = OFFERTES.LEV_CODE) ON PLANTEN.ART_CODE = OFFERTES.ART_CO; This will bring up all suppliers and every...

Hey In my database I am wanting to combine two fields within my sql. To ellaborate: SELECT PLANTEN.PLANTNAAM, PLANTEN.BL_B, PLANTEN.BL_E FROM PLANTEN; This results in three columns: PlantNaam Bl-B BL-E Tulip 4 7 I am wanting to combine the two columns...

Heya, I was working on an sql problem and solved it: SELECT planten.PLANTNAAM, planten.SOORT FROM PLANTEN AS planten WHERE (((planten.ART_CODE) Not In (SELECT offertes.ART_CO FROM OFFERTES offertes, BESTELRG bestelrg, BESTEL bestel WHERE offertes.ART_CO_LEV = bestelrg.ART_CO_LEV...

I am trying to create an IN query (ACCESS) which will firstly show the customers table (specific details) then the orders details should be in the IN query, I formulated this but it won't work: SELECT s.CustomerID, Address, City, PostalCode FROM Customers s WHERE s.OrderID IN (SELECT s.OrderID...

Hello all, I am currently working on an sql query to find employees which handled more orders than average in a certain half year. For arguments sake the half year is august-dec1997. I will use two queries, one to calculate COUNT and one for the avg: So far I have the COUNT query sorted...