basically i need to generate a birthday list. both tables contain personal info. i can easily do a query for one table, but i would like to have both clients and staff on the one the list. at the moment i am trying to make a relationship between client IDs and staff IDs (all of which are unique)...
I have two tables. one for clients and one for staff. none of the data is yet in anyway linked. i would like a query that will order both sets of data according to their date of birth in one query. as you may have noticed, i am a real novice so any help would be appreciated : )
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.