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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is is possible to solve this Issue using SQL
Hi there, I've never actually used them, but you might want to look into "heirarchical queries". I believe they do exactly what you want, and may be the only way to "traverse" a tree of data in SQL. I've seen heirarchical queries referenced in Oracle docs - I'm not sure... -
Repeating rows
Thanks for your reply, John, but that query will only return one row for each match. Perhaps I wasn't clear. If I have data: Deck (DeckID, DeckName): 1 sacham's deck 2 your deck DeckCard (DeckID, CardID, Count): 1 1 1 1 2 2 2 3 1 2 4 4 Card (CardID... -
Repeating rows
I have three tables: Deck: DeckID DeckName DeckCard: DeckID CardID Count Card: CardID CardName I want to write an SQL statement that returns a given Card row DeckCard.Count times. Is this possible? Any help is appreciated, sacha
