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

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:

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>

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


  • 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.
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    This still hasn't been fixed in, 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.)

Sign In or Register to comment.