multiple left outer joins on query of query

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 425,824 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,976 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ColdFusion advertiser: Programming Forums

Thread Tools Display Modes

Views: 836 | Replies: 1

•

Join Date: Jul 2008

Posts: 1

Reputation: tassz444 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

tassz444

Offline

Newbie Poster

multiple left outer joins on query of query

Jul 2nd, 2008

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

•

Join Date: Feb 2008

Posts: 70

Reputation: cmhampton is an unknown quantity at this point

Rep Power: 1

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: multiple left outer joins on query of query

Jul 2nd, 2008

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.