Help tuning a very poor SQL query

[eluser]jedd[/eluser]

That said, is it technically possible to do any kind of JOINs even if the tables aren't named well, ie using AS to cast it to a different name for the query instance?

Of course .. you can cast any of those fields using an AS. That's the easy bit.

I got errors on that join and fiddled a bit but haven't got it yet.

Errors ...? Go on .. share them. I don't have a set of tables with a suitably/ speculatively comparable set of data to test my calls against, so I've just dodgied something up. If you have a couple of short INSERT scripts, that'd be handy.

Also, I am trying to get all the rows, EXCLUDING the ones marked "1" in the kg_progress table, can I still use JOIN xxxxxx = 1 in that case or !=1 or do I need a different operand than JOIN?

Of course. Here's one of my nonsensical ones I was playing with earlier.

Code:

SELECT *
    FROM organism
    LEFT JOIN taxa_species ON taxa_species.id!=organism.taxa_species
    WHERE taxa_species.id=1
    AND organism.id=1;

I regret not having been more interested in MS Access in high school computer class

Your disregard of MS Access serves only to improve others' regard of you, I'm sure.