SQL within Excel question

Chris Davison · Mar 20th, 2002, 02:26 PM

Evening all,

this is an SQL question, it's just I'm typing it in an Excel addin that connects to an Oracle database....

cell A1 contains :

SELECT * from acbbankrec WHERE client='TG' AND status ='N'

I want it to bring back info from ALL my clients (TG, PR, FT, FO and TR).... what's the SQL syntax for this ?

sorry, I know this isn't 100% an excel question, but my co-workers can't help and the SQL downloads into Excel and thus my life makes sense again...

many thanks
Chris

Mark W. · Mar 20th, 2002, 02:30 PM

SELECT * from acbbankrec WHERE client In('TG','PR','FT','FO','TR') AND status ='N'

[ This Message was edited by: Mark W. on 2002-03-20 13:31 ]

Chris Davison · Mar 20th, 2002, 02:33 PM

oh fab...thanks Mark....once again, I owe you !

(does the "in" mean "inclusive" ?)

Mark W. · Mar 20th, 2002, 02:35 PM

Quote:

On 2002-03-20 13:33, Chris Davison wrote:
oh fab...thanks Mark....once again, I owe you !

(does the "in" mean "inclusive" ?)

No, it means "in this list". Or, if you prefer "among these..."

[ This Message was edited by: Mark W. on 2002-03-20 13:36 ]

Chris Davison · Mar 20th, 2002, 02:40 PM

ta

[completing this SQL cuts out about 4 hours of copy/pasting into Excel and thus cuts down a regular Monday afternoon duty from 6 hours to about 1 hour start to finish]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 02:26 PM	#1
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Evening all, this is an SQL question, it's just I'm typing it in an Excel addin that connects to an Oracle database.... cell A1 contains : SELECT * from acbbankrec WHERE client='TG' AND status ='N' I want it to bring back info from ALL my clients (TG, PR, FT, FO and TR).... what's the SQL syntax for this ? sorry, I know this isn't 100% an excel question, but my co-workers can't help and the SQL downloads into Excel and thus my life makes sense again... many thanks Chris

Mar 20th, 2002, 02:30 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	SELECT * from acbbankrec WHERE client In('TG','PR','FT','FO','TR') AND status ='N' [ This Message was edited by: Mark W. on 2002-03-20 13:31 ]

Mar 20th, 2002, 02:33 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	oh fab...thanks Mark....once again, I owe you ! (does the "in" mean "inclusive" ?)

Mar 20th, 2002, 02:40 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	ta [completing this SQL cuts out about 4 hours of copy/pasting into Excel and thus cuts down a regular Monday afternoon duty from 6 hours to about 1 hour start to finish]