V4RB ... SQL really

[Pedro fp]

Extending on this ... would ...
	WHERE tableB.RecID = 0
get records with no related records?

If so, would including tableB,RecID in the field list of SQL queries 
made on table A be a good way for the records in the resultant cursor 
to 'know' whether they have related records?

On Friday, April 11, 2003, at 01:00  AM, Pedro fp wrote:

> Can someone please tell me what SQL where clause you would use to get 
> all the records in table A that have *no* related records in table B?

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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"What difference does it make to the dead, the orphans, and the
homeless, whether the mad destruction is brought under the name
of totalitarianism or the holy name of liberty and democracy?"
                                            M K (Mahatma) Gandhi