Sherlock, Ric <[EMAIL PROTECTED]>
wrote:
But gives and error with the following statement (it will run fine on
the same tables in Access)
SELECT clients.cl_lname, clients.cl_title, price_profiles.pp_year,
prices.pr_mfd, prices.pr_price
FROM (clients LEFT JOIN price_profiles ON clients.cl_id =
price_profiles.pp_client) LEFT JOIN prices ON price_profiles.pp_id =
prices.pr_pp
SQL error: no such column: clients.cl_lname
Known SQLite limitation. Just drop the parentheses, you don't need them
here.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
