SELECT ERROR: ERROR:  missing FROM-clause entry for table "dlr_dealer2dlr_region"<BR>
SELECT QUERY ERROR: fields: *, tables: dlr_dealer,dlr_region, where: dlr_region.defined_id = dlr_dealer2dlr_region.dlr_region_id AND dlr_dealer.dlr_dealer_id = dlr_dealer2dlr_region.dlr_dealer_id AND NOT dlr_dealer2dlr_region.dlr_region_id = 1 AND dlr_dealer.dealer_type = 'Rep', order: last_name, first_row: 0, row_count: 0<BR>SQL: SELECT * 
FROM dlr_dealer,dlr_region 
WHERE dlr_region.defined_id = dlr_dealer2dlr_region.dlr_region_id AND dlr_dealer.dlr_dealer_id = dlr_dealer2dlr_region.dlr_dealer_id AND NOT dlr_dealer2dlr_region.dlr_region_id = 1 AND dlr_dealer.dealer_type = 'Rep' 
ORDER BY last_name <BR>