Help with SQL query

Zipppy

Hi all
An SQL query driving me mad...

three tables (I'll shorten the fields)
Tables: Venue, Symbol, Venue.Symbol

Venue - VenueId, name, address1, address2, telephone etc
Symbol i- SymbolID, Image
Venue.Symbol - VenueId, SymbolID

each venueID in venue.symbol may have several records (ie symbols)
I want all venue details once but symbols listed afterwards (dont want all venue details repeated for every symbol associated) as I'm going to format these in a report

---

eg

22
Zipppys Bank
Main Street
Dublin 2
01 8976737

Image ofSymbol2
Image of Symbol3
Image of Symbol4

next record................................etc

druidhill

What SQL statement have you got so far?

stevenmu

If you don't have a set number of symbols per venue, and you don't want to repeat the venue details for each symbol, then you'll need to do two queries, one to get the venue, then another to get the symbols for that venue.

Zipppy

ok have this sorted (i think ) thanks for replies
Zip

Colonel Panic

Hi, you should post your solution if you sorted it yourself. Some poor soul might have the same problem as you and wonder what you did!