Please have a look on this group by

Hi Folks, now sitting here for 5 hours trying to get these stupid sql-request running, I decide to ask the list. structual information of the database: database.preis = decimal(12,2), database.lfd=int(11), database.typ=varchar(30), database.marke=varchar(50) The following requests works select

SOLVED ..Please have a look on this group by..,not really

Again, thanks to all, who helped. None of your advices gave the desired pair combination >single row preis/ lfd<, but just looking at the first row, gave the correct answer as I grouped by preis, lfd. I was irritated by the results, the command-line gave me. Even as I wanted the quantity of retu

Re: basic query question

At 19.02.2002 10:22, you wrote: >I'm fairly new to MySQL, so if anyone could help me I'd really appreciate >it! > >What I'm trying to do is join two pictures in a database to each other. My >database holds info about people with variables: > >id, lname, fname, engagedto, pic Try this, even if I´

Getting "NO format" output from cmd-line ?

Hi Folks, I use a shell script, to get data from a mysql database. I use the following call mysql -ddatabase -uusername -ppassword < file_with_sql_select >file_to_get_output I even tried mysql -e select foo from database -uusername -ppassword >file_to_get_output but I always get as first line th

Re: question on selects in multiple tables

At 01.01.2002 23:12, you wrote: >OK... let's say I have two tables. Let's say one is an inventory >table, a bunch of items. One of the fields is for the inventory >items that have been sold, and are keys to the second table, which >is a list of customers; names & addresses. > >So let's say I w