Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

> FWIW:
>
> I seldom do much more than add the tables in MS Access's <OPINION> stupid
> </OPINION> query design thingy.  I immediately use the menu to view SQL and
> just type the SQL I want.  Obviously, different folks think different ways,
> and maybe you actually understand and like that MS Access point and click
> interface that I hate, but I want to be sure you're at least aware that if
> it sticks an ORDER BY in there that you never asked for, you can just rip
> the damn thing out in the SQL view and then run the query...  At least,
> that's how I make it give me the SQL I really want, instead of the SQL it
> thinks I want, which it never gets right anyway.

Since I'm learning SQL in my spare time, I tend to use these feature in MS
Access and PgAccess to point me in the right direction or sometimes
confirm, or deny my assertions.

I like psql, but its not the kind of tool which suggests other
alternatives. It just says "this part is bogus." That's fine, but when I
fail to get it right after a dozen attempts, its nice to let something
else take a stab at it.


Bruce Tong                 |  Got me an office; I'm there late at night.
Systems Programmer         |  Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE  |
zztong@laxmi.ev.net        |  -- Joe Walsh for the 21st Century