Member Avatar for tassz444

Hi

Trying to do multiple left outer joins on query of query.
Have asked on forums if ColdFusion supports this, although there are workarounds for single left outer joins on query of query, it is not what I require.
It appears that no one has attempted to do this on multiple primary keys before!

Can you tell me if this can be achieved?

Tassz444

  • 2 Contributors
  • 1 Reply
  • 57 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by cmhampton
Member Avatar for cmhampton

I'm not aware of any way to get this to work in CF. However, in your SQL query/stored procedure, you could put the data into temp tables, join them there and then return the results to CF. This would eliminate the need for QoQ joins.

Let me know if you want some help doing that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.