I need help on approaching a report I have to develop.
I have two tables.
One is registration for a conference.
- fields of concern are Sess1, Sess2, Sess3, Sess4, Sess5 and Sess6
Second is a list of sessions.
- two main fields ID and SessionName
My goal here is to design a query that would:
- Read each individual unique ID from Sessions Table then report the Session Name and Count it appears for each from the Registration Table (the ID could appear in any of Sess1 thru Sess6 fields; but only one of them)
Should be simple enough but admittedly I am not a SQL guru and was hoping someone could help me out and save me a bunch of headaches trying to figure this out.
Dear Sir, We would love very much to be given the opportunity to work with you on this project. We are expert. We can do this according your requirements. Please see PMB.
12 freelancere byder i gennemsnit $38 for dette job
Hi Penhall! Can send to me details of 2 tables? And,what do you use them for ?? I have seen a proplem in your table's design. If possible, i'll help you to redesign them.