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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple records in a select
Basically I am using a select statement for an application we have just bought. It's an oracle database. The problem is that all I can use is a select and nothing else, otherwise I could have used some temporary tables and stuff - it's a disaster but your answer has been a great help. Thanks -
Multiple records in a select
Thanks for this, it works perfectly. Only thing is I have come across another problem as there can be anywhere between one to ten attributes for each product.... Any more suggestions?? -
Multiple records in a select
I have a table with consisting of products and product id's. I then have a table of attributes consisting of product id,attribute id and attributes. My issue is I want to join the two tables but only return 1 row. I.e if I have a product description of a hammer with a product id of 1. In the...
