Is there an alias that is used for the data grid filters to reference the table? I have a table that I’m needing to find rows based on values in another table and in the sub-query need to reference the alias for the main table. It would be extremely useful for me to be able to do this using the schema browser data grid or a Describe data grid so the arrangement of my columns can be remembered between sessions.
Here is the entire query that I’m using, in case it makes more sense what I’m trying to do here.
SELECT ROWID, loc.*
FROM wc_geo_locations_d loc
WHERE (loc_match_city_name, loc_match_region_name, loc_country_wid) IN (SELECT loc_match_city_name,
FROM wc_geo_locations_d loc2
WHERE 1 = 1
AND NVL(loc.loc_official_geoname_id, 0) <> NVL(loc2.loc_official_geoname_id, 0));
Digital Strategies, Cru | Data Sciences & Analytics