Marcos Henke Wrote:
SELECT a.* FROM company a, employee b
WHERE a.id=b.cid AND
(b.name='joe' OR
b.name='bill');
This will pull out all companies which have a Joe or a Bill. We want only the
company in which Joe and Bill are working.
A working solution was offered by Adolfo Bello earlier
it looks as though you have created the newsletter user with plain text password.
mysql will compare the user password against the encrypted password and will fail.
you can do this:
mysql set password for newsletter@localhost=PASSWORD(testPass);
or
mysql update user Set
please look at page 194 of the reference manual...
(and if so how do you ask MySQL to create a temp table from the
results of aquery?)
here's an example:
mysql create temporary table tmp (name varchar(20), owner varchar(20, species
varchar(10));
mysql insert into tmp select name, owner,
If I understand you correctly you like to have the result for the specific table in
your mail to look like this:
200 -- this is the total price of item1 (1 * 200)
150 -- this is the total prices of partAs (2 * 75)
300 -- this is the total price of partBs (2 * 150)
for this you are better off