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 |
|
a4nsd
Starting Member
20 Posts |
 Posted - 2007-01-05 : 20:53:58
|
Dear my expertsI have a table called tbl_ShoppingCart with these fieldsCartID,ProductID,ProductName, CustomerName,Ownedbywith OwnedBy is an email of person who has product.ExampleCartID=1;CustomerName=abc;ProductID=1;ProductName= Name1;OwnedBy: abc@yahoo.comCartId=2;CustomerName=abc;ProductID=3;ProductName=Name3;OwnedBy: def@yahoo.comCartId=3;CustomerName=abc;ProductID=5;ProductName=Name5;OwnedBy: abc@yahoo.com My problem is: I want to get the records to send to the OwnedBy with their products. How can I query these fields..Thanks alot.I am a beginner... |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-06 : 03:30:47
|
| SELECT * FROM tbl_ShoppingCartWHERE OwnedBy = 'abc@yahoo.com'? |
 |
|
|
|
|
|
Get records ...need some help...