Inner Join - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Inner Join

Author

Topic

kdnichols
Posting Yak Master

232 Posts

Posted - 2007-02-15 : 11:38:27

Hello,

I have the following code:


and ir_tech_ojb between 950 and 999
and compl_dte_ojb BETWEEN '&low' AND '&high'
and prin_ocr = 8600
order_no_ocr = order_no_ojb

And I get the following error message:

sg 102, Level 15, State 1, Line 45
Incorrect syntax near 'order_no_ocr'.

Thanks,

Kurt

Kristen
Test

22859 Posts

Posted - 2007-02-15 : 12:10:43

and ir_tech_ojb between 950 and 999
and compl_dte_ojb BETWEEN '&low' AND '&high'
and prin_ocr = 8600
XXX order_no_ocr = order_no_ojb

You need AND or OR or somesuch at the XXX point

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources