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