Radicore Forum: How To » override auto rdcaccount_id clause in a manually extended SQL

Home » RADICORE » How To » override auto rdcaccount_id clause in a manually extended SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: override auto rdcaccount_id clause in a manually extended SQL [message #1997 is a reply to message #1990]

Mon, 20 April 2009 12:46

gpatti
Messages: 283
Registered: August 2008

Senior Member

Of course it WAS my coding - my SQL is a bit rusty and I was getting a cartesian product across the two tables. I needed to specify manually a join between the rdcaccount_id on each table. Everything working perfectly now.

Thanks again.

Graham

Report message to a moderator

[Message index]

		override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Sun, 19 April 2009 11:07
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Sun, 19 April 2009 18:36
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Sun, 19 April 2009 19:37
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Mon, 20 April 2009 05:25
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 08:51
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Mon, 20 April 2009 11:03
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 11:59
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Mon, 20 April 2009 12:46
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 08:57
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 09:15
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 09:34
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 09:45
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Tue, 21 April 2009 10:11
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Tue, 21 April 2009 11:07
		Re: override auto rdcaccount_id clause in a manually extended SQL By: AJM on Thu, 23 April 2009 04:47
		Re: override auto rdcaccount_id clause in a manually extended SQL By: gpatti on Thu, 23 April 2009 05:16

Previous Topic:	Use Messages[] in a LIST1 transaction
Next Topic:	Dynamic Task Selection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 20:43:30 EST 2024

Total time taken to generate the page: 0.01130 seconds