Hilary,
While the below containstable query examples provide a solution, it does not
meet John's requirement of  'search across 3 columns, "author", "title", and
"subtitle"' and I submit that using the following FT-enabled Northwind table
(Employees) and multiple column specific column names (vs. using "*" or
asterisk for all FT-enabled columns) does meet John's request, for example:

use Northwind
go
SELECT LastName, FirstName, Title, Notes from Employees
/* returns:
LastName             FirstName  Title
-------------------- ---------- ------------------------------
Davolio              Nancy      Sales Representative
Fuller               Andrew     Vice President, Sales
Leverling            Janet      Sales Representative
Peacock              Margaret   Sales Representative
Buchanan             Steven     Sales Manager
Suyama               Michael    Sales Representative
King                 Robert     Sales Representative
Callahan             Laura      Inside Sales Coordinator
Dodsworth            Anne       Sales Representative
(9 row(s) affected)
*/

-- an expanded version of your example. Note, that this query will return
all 9 rows that contain Fuller (LastName column) OR Sales (Title column)
SELECT e.LastName, e.FirstName, e.Title
  from Employees AS e,
  containstable(Employees,*,'Fuller or Sales') as A
      where
        A.[KEY] = e.EmployeeID

--or this example that will also return all 9 rows that contain Fuller
(LastName column) OR Sales (Title column)
SELECT e.LastName, e.FirstName, e.Title
  from Employees AS e,
  containstable(Employees,*,'"Fuller" or "Sales"') as A
      where
        A.[KEY] = e.EmployeeID

However, John wants to 'search across 3 columns, "author", "title", and
"subtitle"' and the user types "chemistry brown" into a search box, (the
Author being "Brown" and the title "Chemistry"). Note the request is for an
AND'ing between the FT-enabled columns and not an OR between the columns.
This can be satsified via using multiple CONTAINSTABLE clauses and AND'ing
the join between Containstable predicates, for example

SELECT e.LastName, e.FirstName, e.Title
  from Employees AS e,
    containstable(Employees, LastName, 'Fuller') as A,
    containstable(Employees, Title, 'Sales') as B
      where
        A.[KEY] = e.EmployeeID AND
        B.[KEY] = e.EmployeeID
go
/* -- returns:
LastName             FirstName  Title
-------------------- ---------- ------------------------------
Fuller               Andrew     Vice President, Sales
*/

John, you can also use the workarounds that are documented for this issue in
SQL Server 7.0 KB article "286787 (Q286787) FIX: Incorrect Results From
Full-Text Search on Several Columns" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;286787 as well as
SQL Server 7.0 KB article "294809 (Q294809) FIX: Full-Text Search Queries
with CONTAINS Clause Search Across Columns" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;294809. You should
note that while these SQL Server 7.0 specific KB articles are "fixes" for
SQL Server 7.0, this is the default behavior for SQL Server 2000 and SQL
Server 7.0 was "fixed" to comply with the default behavior of SQL Sever
2000. The workarounds in the KB articles will also work in SQL Server 2000
as well as the above solution that I provided above.

Regards,
John