It sounds like the following requirement got you thinking about the problem
in the wrong way, though you still came up with a viable solution:
> invoices need to list all purchase orders, sales orders, and
> adjustments for a given time period. I could display the invoice
> and then display pu
I think you may have introduced the >From typo, but it is one regardless. I
don't think the parens are necessary. Try it out.
Ted Gifford
-Original Message-
From: Gregory A. Swarthout [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 9:44 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROT
Sounds like you want to do:
Select store_name, t1mgr.manager_name as 'type_1_manager',
t2mgr.manager_name as 'type_2_manager'
>From (keystone_stores ks left join managers t1mgr on ks.id = t1mgr.store_id
and t1mgr.manager_type = 1)
Left join managers t2mgr on ks.id = t2mgr.store_id
and t2mgr.mana
Run everything off a ramdisk ;-)
Ted Gifford
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 5:21 PM
To: [EMAIL PROTECTED]
Subject: Improving seek/access times -- does RAID help?
Hi all,
Can anyone tell me whether or not some kind of RAID will
Why not:
SELECT * FROM table1, table2 WHERE
table2.columnB = 'this' AND
FIND_IN_SET(table2.columnA, REPLACE(table1.columnA,';',',') ) > 0
Documented here: http://www.mysql.com/doc/en/String_functions.html
Ted Gifford
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
S