Whats On
WhatsonID

Venue
Venue Location
Venue Address
Venue Town

Type
Event Location(If different from venue location)
Event Address
(If different from venue address)
Event Town
(If different from venue town)

From @
To @
Title
Description
Link 1
Link 2
Start Date


set dateformat dmy select venueLinkid,startdate, title, whatsonid, whatsontype, datefrom, dateto, image, address, town from tbl_whatson, tbl_whatsontype where tbl_whatson.type=tbl_whatsontype.whatsontypeid and dateto>getdate() order by datefrom, title
IDVenueTitleTypeFromToDurStart
Companies not assigned to a venue
Companies with no town