Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 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
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