Join condition not working in VBA

**cruise.alter** · 07-07-2012, 12:30 AM

Hello everyone,

I am putting one join condition to retreive data from oracle database using VBA. But getting syntax error (compiled error).
Can anyone help me to check. Without putting join condition, I am getting data.
Is there any URL where I can learn about SQL VBA to know the rules and process.

Please Login or Register  to view this content.

**JosephP** · 07-07-2012, 07:49 AM

you can't use a line continuation character in the middle of a string so this

Please Login or Register  to view this content.

needs to be

Please Login or Register  to view this content.

**cruise.alter** · 07-07-2012, 12:21 PM

Thanks joseph.. As I am using SQL for first time in VBA, I am asking this type of question.

i) In my database, I want to use join for around 10 tables. In that case, what should be my approach. If I will not use line continuation then the code will be too lengthy.Can I use the same code like below.
ii)Also if I use outer join, whether can I use (+) like below or outer join keyword ...
iii) If I search for a single keyword( like m.marketing ='CTS' ), then can I use single quote(')

Please Login or Register  to view this content.

Advance thanks

**JosephP** · 07-08-2012, 11:20 AM

I didn't say you couldn't use them I just said you couldn't put them in the middle of a string. you need to concatenate the strings as I showed

**James Donovan** · 07-31-2012, 06:19 PM

I think there's problem with string I didn't get proper result. plz help me out ..

**JosephP** · 08-01-2012, 01:37 AM

start your own question please

**Cutter** · 08-01-2012, 08:12 AM

Hello James Donovan.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.