What are the challenges you face when working across database platforms? Take the survey
Options

No join suggestions

MikeyCMikeyC Posts: 249 Bronze 3
I have the option turned on in SQL Prompt 3.6 EA to suggest joins based on field names, but when writing this query:

SELECT
tdl_id
FROM edic_cga_details d
INNER JOIN (SELECT tx_id, SUM(amount) as amt FROM edic_cga_details WHERE detail_type=42 GROUP BY tx_id) a
ON <cursor>
WHERE
DETAIL_TYPE=10;

When I type a space at <cursor> it brings up a list of table aliases and field names, but no join conditions. The only possible join is on TX_ID since it exists in both sources. (AMT doesn't exist in the source table edic_cga_details.)

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Interesting. I would have thought that would work and I'm not really sure why it doesn't. We'll look into it.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    This still hasn't been fixed in 3.8.0.244, but I am able to narrow it down to the ON candidates are not honoring my option of ignoring the case of the field names. (The field is in all upper case in the table.)

    Michael
Sign In or Register to comment.