Hellooo
I don't know if I understand it.
There aren't seperate tables for schools, or for subjects.
claireWXY
Last Activity: Feb 28 '07, 04:34 PM
Joined: Feb 5 '07
Location:
-
Hi guys, I think ronverdonk hit the nail on the head... They come up as individual rows, so this method may be impossible. Is there anyway of having the first record appear, then additional columns show up on the same row?
Allow me to explain....
I have one table called 'orders'. Orders is pretty awesome, It holds the name and address, the unique key is the 'OrderEntryId' column.
I have another table...Leave a comment:
-
Complicated Query
Hi! I have been asked to sort a table into a patricular order to be used with a mail merge, however, I have no idea where to start with the query!
The table currently consists of Schoolname, Address, Subject.
Single schools can have multiple subjects. For example,, may return 4 rows, all the same except for the 'Subject' column, which could contain 'Mathematics', 'English',...Code:SELECT * WHERE schoolname='The Streetly School'
No activity results to display
Leave a comment: