my sql question "join"

i have a problem in syntax
"from table1 LEFT [OUTER] JOIN table2 ON table1.xyID=table2.xyID"
i have an error message in OUTER
please help me to ind my wrong syntax in there..thank you.

Nov 20 '11 #1

Subscribe Post Reply

1568

Rabbit

12,516

Expert Mod 8TB

Take the brackets out.

Nov 21 '11 #2

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!