I'm struggling to get what seems like a perfectly normal query to execute in MapInfo v10.
In SQLite Manager (an excellent firefox plugin), this works as expected:
SELECT area_name, street_name, address, disp_lon, disp_lat FROM mtdArea, pointAddress, streets WHERE (streets.link_ID = pointAddress.link_ID) AND ((l_area_ID = area_ID) OR (r_area_ID = area_ID))
The equivalent in MapInfo
SELECT RationalisedMtdArea.Area_Name, RationalisedStreets.Street_Name, RationalisedPointAddress.address, RationalisedPointAddress.Disp_Lon, RationalisedPointAddress.Disp_Lat FROM RationalisedMtdArea, RationalisedPointAddress, RationalisedStreets WHERE RationalisedStreets.Link_ID = RationalisedPointAddress.Link_ID And ((RationalisedMtdArea.Area_ID = RationalisedStreets.L_Area_ID) Or (RationalisedMtdArea.Area_ID = RationalisedStreets.R_Area_ID))
..gives me a
No Join specified between tables RationalisedMtdArea and RationalisedPointAddress.
Invalid join condition in WHERE clause.
Does MapInfo not like logical
What am I missing?