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 |
|
goblyn27
Starting Member
39 Posts |
 Posted - 2001-10-21 : 01:06:50
|
| Hi there, Im trying to do a very specific select query and I cant seem to get the syntax right, so I figured I'd pose the situation up here and see if there's anoyone more awake then I am that wants to give it a shot.Here's my two tables I will be running a select statement onTable 1 PrevID, Title, Publisher, PriceThis table conatins a list of about 1000 magazine items in it.Table2 UserID, PrevID, QuantityThis table holds all the orders placed for all the magazines, until such time as they can be processed.What I am trying to achieve is a listing of all the items, and where a particular User (UserID) has placed an order, a quantity for that order. Everything Im trying is coming up with a list of just the items that the user originally ordered which is no bueno. Example Desired ResultSet: Item1, Title1, Publisher1, Price1, Null Item2, Title2, Publisher2, Price2, Quantity2 Item3, title3, publisher3, Price3, Null Item4, Title4, Publisher4, Price4, Null Item5, Title5, Publisher5, Price5, Quantity5Thanks in advance to anyone that wants to lend a hand on this. It is greatly apreciated.--peter"DuuuDe!! I suck!" |
|
|
|
|
|
|
|
SQL Query Help--TIA