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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sacham

    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...
  2. sacham

    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...
  3. sacham

    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

Part and Inventory Search

Back
Top