Hmmm good to see you found a simpler way to work it out,
However I think its best to warn you that if tomorrow you need to replace that "*" with the actual column names you will have a few issues...

Since your records are and will be truly unique by date (as you have mentioned in the edit comment), you could use a simple join query like this:-


SELECT A.id, A.profile_id, A.recipient_id,...

If you want the MySQL J-Connector driver to be available to all your Java applications then you should copy the "jar" to "$JRE_HOME/lib/ext", If you have a JDK installed then the location would be...

Please avoid chat speak or Sms speak its against the forum rules and doesn't even sound professional.

Also define what you mean by "doesn't work". Give us sample data of the tables and what you...

Would you care to elaborate on that with an example which illustrates what you exactly want ???

What is the Error that MySQl threw at you ??

Also did you remember to put the "END" at the end of the Trigger.

That should be simple :-


SELECT *
FROM customers
WHERE customers_id NOT IN (
SELECT customers_id
FROM orders
)

Check what encoding you have set for your web page, If it is Latin 1 (ISO-8859-1) then the Greek characters will not be displayed.
You could check for without touching you code by browsing to your...

Whats the error MySQl is throwing ?

I don't think the following should make a difference but have you tried like this :

SELECT a.d_key_id, AVG(a.score) as 'avg' FROM
(SELECT d_key_id,...

See if this (http://dev.mysql.com/doc/refman/5.0/en/windows-source-build.html) answers any questions.

Strange no one recommended the MySQl reference manual as yet. I found it the best guide for all my MySQL questions.


http://dev.mysql.com/doc/refman/6.0/en/index.html

Well checked it out but honestly I found the reference manual more comfortable to look up to but I guess it will differ from person to person (since I have been using the reference manual for almost...

Well the reference Manual on the MySQL site is a pretty good place to start learning MySQL.

First requirement of its types I have seen, Whats the schema ?

-------------
Shucks dint see the last post was 5 days ago

I think the thread starter is talking about PHP and you r confusing it with the J-Connector.

So how are you connecting to the database, can we have some code to see what you tried ?
First hit the...