Re: SQRT / Pythagoras Query problem

[Rick James]

> How do I limit the returns to only those distances less than 10?

HAVING distance < 10

or add this to the WHERE clause:
SQRT(...) < 10

> mydb.Assign.Attract

MySQL does not have a "dbo" part. Tables references are of either of these forms:
table_name
database_name.table_name
but not
db.dbo.tbl