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.
| Author |
Topic |
|
websyd
Starting Member
16 Posts |
 Posted - 2006-07-12 : 07:51:02
|
| Ok i hav three tables namely customers, orders and products.This are there structures Customers-: CustomerId-PK FirstName LastName Address Orders -: OrderId -PK QuantityOrderd OrderDate CustomerId -FK ProductId -FK Products -: ProductId -PK ProductName UnitPricemy question is that i need to relate them so that i can get info on a customer orderThanks |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-07-12 : 10:00:59
|
select * from Customers c inner join Orders o on c.CustomerId = o.CustomerId inner join Products p on o.ProductId = p.ProductId You can learn more about SQL here...http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.aspRyan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
 |
|
|
|
|
|
Inserting Records again