Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Whats wrong with my Inner Join 2

Status
Not open for further replies.
VonFranzken

VonFranzken

MIS
Mar 17, 2005
147
US
SELECT aid, articletitle, shortdescrp, eventdate, datenow
FROM articles
INNERT JOIN comments
ON articles.aid = comments.aid
ORDER BY articles.datenow DESC

It keeps telling me syntax error in from clause?

Much appreciated.
Steve
 
Sort by date Sort by votes
you have written 'innert' rather than inner.
If that's just in the post and not the syntax let us know.
 
Upvote 0 Downvote
After fixing the INNERT issue, you will likely get another error. You are selecting a field named 'aid'. This field appears in both tables, so SQL Server will not know which field you really want. You will need to specify the table name.

Ex...

Select Articles.aid, .....


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
894
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Returns wrong results
Replies
1
Views
141
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
532
gmmastros
gmmastros
RazorEddie
  • Locked
  • Question
Simple query gone wrong
Replies
10
Views
199
RazorEddie
RazorEddie
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
468
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top