Sort a Sum

Is there any way to do the following? I get an error whenever I try this (Invalid use of Group function). Select Product, Sum(Qty) >From Inventory Group By Product Order By Sum(Qty) DESC; I want the total quantities for all products but I want to see the products with the highest quantities fir

Re: Query across two databases on the same server

I found the problem. There was a hyphen in my database name. Re-created the database and re-imported my data, now everything works fine. Thanks to everyone. >>> Egor Egorov <[EMAIL PROTECTED]> 3/25/04 8:19:04 AM >>> "Ed Reed" < [EMAIL PROTECTED] > wro

RE: Query across two databases on the same server

yea, I thought it would be that easy too but it doesn't work. Any other ideas? >>> "Peter Lovatt" <[EMAIL PROTECTED]> 3/24/04 3:53:03 PM >>> select db1.table.field, db2.table.field where db1.table.someotherfield = db2.table.someotherfield Peter >

Query across two databases on the same server

Is there any way to have a single select statement that can do a join across two databases on the same server? Thanks

REGEX in an Order By clause

How do I use a REGEX expression in the Order By clause? I have a column which contains data that looks like this, A002C A001 A1000C B100AA CAR A023 I use a query like this that sorts everything but the occasional last aphla character Select field From table Order BY Left(1,field ). Right(fi

re: Union Query Sorting

Thanks Jeremy, That was easy. - Ed >>> Jeremy March <[EMAIL PROTECTED]> 3/12/04 7:42:12 PM >>> > Can anyone tell me how to sort the combined results of a Union query? > > (Select Name From Employee Group By Name Order By Name) > Union (Select Name From Consultant Group By Name Order By Name);

Union Query Sorting

Can anyone tell me how to sort the combined results of a Union query? Right now I have a Group By and Order By in both of my queries that make up my Union but the results are grouped and sorted within the two queries but not between the two queries. The example below demonstrates my problem. In the

Re: AW: Query error in Access

PROTECTED]> 2/26/04 12:25:03 PM >>> Ed The MS Access SQL syntax for if() is iif(condition, then stuff, else stuff) Maybe that's the problem, I am not sure - try it Freddie -Ursprüngliche Nachricht- Von: Ed Reed [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 26. Februar

Query error in Access

Hello Everyone, If I run the following query in MySQL Control Center or MySQL-Front it works correctly, SELECT -1 AS ProductID, "Add New Part" AS PartNumber, "" AS VendorPartNo, "" AS Description, "" AS VendorStatus FROM Products UNION SELECT ProductID, PartNumber, If(SubNo=1135, VendorPart,A

Privileges By Groups

Is there any way to assign Privileges to databases/tables/fields via Groups rather than user by user?

Financial packages

Does anyone have a list of manufactures of financial packages that will run with MySQL? We need to move from Intuit Quickbooks to something that can potentially scale to as many as 200 users. Greatplains and Solomon appear to only run on SQLServer. Any suggestions or past upgrade experiences woul

Financial packages

Does anyone have a list of manufactures of financial packages that will run with MySQL? We need to move from Intuit Quickbooks to something that can potentially scale to as many as 200 users. Greatplains and Solomon appear to only run on SQLServer. Any suggestions or past upgrade experiences wou

Financial packages

Does anyone have a list of manufactures of financial packages that will run with MySQL? We need to move from Intuit Quickbooks to something that can potentially scale to as many as 200 users. Greatplains and Solomon appear to only run on SQLServer. Any suggestions or past upgrade experiences wo

Re: Multiple Inserts and updates

---+-+--+ | 1 | 56-56 |5 | | 2 | 27-01 |1 | | 3 | 15-02 |2 | ++-----+--+ 3 rows in set (0.00 sec) It really seems to work ;) Regards, Joseph Bueno Ed Reed wrote: > I created a new table called Table1 and did a test with that command. My > test table does have

Re: Multiple Inserts and updates - Opps!

5), ("27-01", 1), ("15-02", 2); If it does not work, you should also post the error message you are getting from mysql. Regards, Joseph Bueno Ed Reed wrote: > Thanks for the response. I tried your example but it doesn't work, > Here's my SQL, can you tell wha

Re: Multiple Inserts and updates

um, Qty. May be replacing 'Product' with 'PartNum' will help. You should only remove outer parens: Insert Into Table1 (Product, Qty) Values ("56-56", 5), ("27-01", 1), ("15-02", 2); If it does not work, you should also post the error message you are

RE: Multiple Inserts and updates

ens. Thanks >>> "Adolfo Bello" <[EMAIL PROTECTED]> 12/1/2002 5:42:34 AM >>> INSERT INTO your_table(fields_list) VALUES (record_1),(record_2),...,(record_n); > -Original Message- > From: Ed Reed [mailto:[EMAIL PROTECTED]] > Sent: Saturda

Multiple Inserts and updates

Can anyone give me an example of how to insert and/or update multiple records in the same table simultaneously? I have a table with three fields; ID, PartNum, Qty. The user enters PartNum and Qty data in an unbound grid UI. When the user hits "Save" I'd like to build a single SQL statement from th

Re: Is it possible to export data from access to MySQL?

I used MyAccess to convert my 40mb .mdb file into MySQL and it works great. You can find it and a whole bunch of other conversion tools on the MySQL site in Downloads/Other. Here's the link, http://www.mysql.com/downloads/os-win32.html Good Luck >>> "Steve Jackson" <[EMAIL PROTECTED]> 11/26/02 6

Re: Count Rows in two tables

Does it have to be in a single query. You could use a Union query and then total the results in your program. Select Count(Field1) >From Table1 Union Select Count(Field1) >From Table2; >>> "Rick Baranowski" <[EMAIL PROTECTED]> 11/12/02 5:10:14 PM >>> Hello all, Does anybody have a SQL string

Re: How to link tables in MySQL

You can still use Access to build your queries then click the SQL button and you'll have the the code for the command line. Access SQL is a little different but you should still be able to get an idea on how to do it. - Ed >>> tmb <[EMAIL PROTECTED]> 11/12/02 12:41:49 PM >>> 1 - any way to search

RE: Newbie Question - Query works in access but not MySQL

tblInvTransaction ON Products.ProductID = > tblInvTransaction.ProductID > Where ((Products.PartNumberLike "%A-000%") AND > (Products.Obsolete<>-1)) > GROUP BY Products.PartNumber; Mark -Original Message- From: Alan McDonald [mailto:alan@;meta.com.au] Sent: Tuesday, Nove

RE: How to port MS Access to MySQL ??

I used MyAccess and it worked very well. One thing I didn't like was that in any table/field name that contained a space, the space was converted to an underscore. I would've rathered it just removed the space so I wrote some VBA to remove all the spaces from field and table names then let MyAccess

Re: Newbie Question - Query works in access but not MySQL

UPDATE: Still trying to solve this and I think I have something that's a little easier to understand. If I run the following query against MySQL it returns "Unknown column 'Obsolete' in 'having clause'". If I run the query using MSAccess as a frontend to MySQL the query runs correctly (it returns

Re: Newbie Question - Query works in access but not MySQL

I came up with a translation to the first query, which had the two sub-selects, and it now seems to work. I've yet to come up with a solution to the second query, which had the Group By clause. I'd still like to hear some ideas. - Ed >>> "Ed Reed" <[EMAIL P

Newbie Question - Query works in access but not MySQL

This is my first post. I hope it works and please excuse me if I screw up. I have an MS Access database I'm trying to convert to MySQL v4.0.3 for Netware. I use a VB frontend to talk to my .mdb file. So far I've gotten all my data into MySQL using the MyAccess tool I bought. In my VB frontend I'v

<    1   2