* in query

[Jim McColl]

When you add a table to a query there is an asterisk at the top of the list
of fields.

Anybody know the pupose of this ???

 

[Craig Alexander Morrison]

This when selected includes all the fields in the table, even those added
after the query is created.

SELECT dbo_BusinessContact.*
FROM dbo_BusinessContact;

This will return all fields and all records in the table
dbo_BusinessContact.

The effect is similar to opening the table in Datasheet view.

 

[Jim McColl]

This when selected includes all the fields in the table, even those added
after the query is created.

SELECT dbo_BusinessContact.*
FROM dbo_BusinessContact;

This will return all fields and all records in the table
dbo_BusinessContact.

The effect is similar to opening the table in Datasheet view.

--
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited

Thanks gentlemen