C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




joinn and alias in sql


Posted Date: 06 Aug 2008      Total Responses: 1
Posted By: Cathrin       Member Level: Gold     Points: 1


Hi all,
Select * from (Select SupplierCode from Suppliers AS newSupplierCode
inner join (select ProductName from Suppliers as newProductName )) as newtable...

My error is
Incorrect syntax near ')'.

Could anybody help me out of this?



Responses
Author: UltimateRengan    06 Aug 2008Member Level: DiamondRating:     Points: 2
hi,
http://www.quackit.com/sql/tutorial/sql_inner_join.cfm
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/sqlp/rbafymstinj.htm


Post Reply
You must Sign In to post a response.
Next : Please Give me Bast URL for learning SQL SERVER 2005
Previous : Normalization
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers   BizTalk Adaptors    Web Design

email fax service

Contact Us    Privacy Policy    Terms Of Use