Daniel,
Give this a try:
Select * From BigTable Where ID In ( Select ID From SecondTable )
Gary.
Daniel Budmiger wrote:
> hy all,
>
> i have hot a big table with different codes and a
> second table with a certain number of reference-codes.
> how can i select only the rows from the first big table
> which have the same code like in the second reference-
> table?
>
> it must be sort of a subselect...
>
> thanks for your advice.
>
> *****************************************************
> Daniel Budmiger
> Seminarstr. 115
> 8057 Zürich
> Tel 01 / 364 41 55
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
