[ILUG] MySQL & outer joins...
John P . Looney
valen at tuatha.org
Mon Sep 11 21:12:12 IST 2000
I assume that mySQL doesn't accpt the oracle syntax for an outer join -
something like (+) IIRC.
I was trying to do:
SELECT table1.usern as user,
table2.fname as folder
table3.comment as comment
from table1, table2, table3
WHERE table1.usern = 'user' and
(table2.ind = table1.2ind or table1.2ind = NULL) and
(table3.ind = table1.3ind or table1.3ind = NULL);
The idea being that sometimes table1.2ind or table1.3ind can be null, so
I want anything taken from that table to be null. And MySQL isn't
impressed with me ;)
Oh, BTW I got a nice new Epson Stylus 900. Prety. But it doesn't work
with ghostscript worth mentioning about. I downloaded the gimp-print
drivers, and tryed them. I then patched Ghostscript 6.0.1 with the gimp
print drivers too...and it was worse. Colour bleeding, black text is
charcoal gray, anything that is supposed to be blue or red turns out a
Has anyone gotten one of these printers working with ghostscript ? What
sort of options did you use ? I was using:
gs -q -dSAFER -dNOPAUSE -sDEVICE=stp -sModel=escp2-900 -r1440x720
-sQuality='1440 x 720 DPI Highest Quality' -dImageType=1
to no avail...
The words of the unwary are apt to cause needless pain and bloody violence.
- Zen Master Greg
More information about the ILUG