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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sql query help
cheers guys, thats brilliant. I tried PHVs and will give the other a go. -
sql query help
Hi all, I need some more help with a query joining data from two tables. What I want to do is to list the top film ordered. I have an ordered table containing Customer ID and FilmID. In the film table there is also Film ID along with title. Example of customer id field data FILMid... -
help with a sub-query
thats pretty good PHV, very useful. I ran it in access and it only gives me the top town. I guess I need the top two or more towns satisfying the query. so if you had ten customers in Glasgow and ten in Edinburgh they would all appear on the list not just Glasgow. Can you suggest a way of doing... -
help with a sub-query
Hi to everyone out there, I am writing a web-site which lists films. One of the tables is a customers. I have been asked to provide a list of all the customers who reside in the town with the most registrations. For example ten customers in Glasgow, five in Edinburgh etc. The output should cater...
