SQL Server Forums - Inner join HELP!

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

Inner join HELP!

New Topic

Reply to Topic

Printer Friendly

Author

Topic

Crima
Starting Member

USA
17 Posts

Posted - 10/18/2012 : 16:09:46

I've been trying to figure out this problem

Write a SELECT statement that returns all columns from the Vendors table inner-joined with the
Invoices table.

so far i've gotten

SELECT * FROM Vendors
INNER JOIN Invoices
ON Vendor.VendorID = Invoice.VendorID

but it's not liking Vendor.VendorID = Invoice.VendorID
I don't know another way since this is the only way they're related.

Any help helps!

A witty student

mandm
Posting Yak Master

117 Posts

Posted - 10/18/2012 : 16:19:53

If your table names are Vendors and Invoices then your table references need to match in the ON condition. i.e. Invoices.VendorID = Vendors.VendorID

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/18/2012 : 16:20:20

what do you mean its not liking Vendor.VendorID = Invoice.VendorID?

can you elaborate with some sample data?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Crima
Starting Member

USA
17 Posts

Posted - 10/18/2012 : 17:01:29

I just figured it out. Supposed to be "Vendors" instead of Vendor, same with Invoices

-________________- Always a little mistake that drives me nutts.

A witty student

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.