How can we help you today? How can we help you today?

No join suggestions

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.)
MikeyC
0

Comments

2 comments

Sort by
  • Bart Read
    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
    0
  • MikeyC
    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
    MikeyC
    0

Add comment

Please sign in to leave a comment.