[V4RB] SQL dramas again

[Pedro fp]

G'day Folks

I'm trying to select records in the table qualityControl which has a 
Valentina link to the table GenXbase with all the fields I need being 
in qualityControl. So I tried the query ...
	SELECT RecID, * FROM qualityControl WHERE sequence_ptr = 145 ORDER BY 
line
& got error ...
	604 - Can't be updated
then this query ...
	SELECT qualityControl.* FROM GenXbase, qualityControl WHERE 
GenXbase.RecID = 145 ORDER BY line
got me error ...
	640 - [no errString returned but the docs say it's a semantic error]
finally this query ...
	SELECT GenXbase.RecID, qualityControl.* FROM GenXbase, qualityControl 
WHERE GenXbase.RecID = 145 ORDER BY line
wnich didn't return an error :)

Would someone please explain why the first 2 don't work?

Cheers, Pedro :-)

Web: <http://www.pedro.net.au>                    PGP Key ID: 387CD96F
Instant messaging...  AIM: bandidoOfOz  ICQ: 27671678  Jabber: pedrofp
                       MSN: mail at pedro.net.au           Yahoo: pedro_fp
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"[the digital divide] is just a new sticker we use to cover up a
more important word: poverty. I don't think we should worry about
the digital divide nearly as much as we should worry about poverty.
It's all over the planet."
                       Apple co-founder & CEO Steve Jobs, April 2001