thanks agnes, i never thought of trying this to be honest
~M

>Hi Mark;
>
>just like;
>
>

>SELECT;
> Table1.*;
> Table2.Field1,;
> Table2.Field2;
> from Table1;
> inner join Table2;
> on lExpression
>

>
>
>HTH
>Agnes
>
>>Hi all,
>>justa query. if i wanted to select out every field from a table but only 2 fields from a linked second table is there a way to do it without listing all of the fields, something like
>>

>>sele table1(*), table2(field1), table2(field2) from....
>>

>>~M