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

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´m

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 want to

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 the