Lynn, close but I think SirAdrian has it.. I will let you know in a few and thank you both. it was really important that I finish this tonight and I would have been trying alterations of this for hours and hours..lol
I will run this and get back in a few..
Thanks again..
Yeah, that was it SirAdrian.... Geez, looking at my earlier tries, I was waaay off! I guess all of these attempts has taught me a little something so I guess the time spent wasn't a total waste. lol
At one point I was soo close. I had everything correct but instead of userfield.field## --I just had field##--I thought that because I clarified the userfield already I didn't have to clarify it again. When I ran that query it was trying to pull field## from the usergroup table and not the userfield table...
I understand now..
You both are great.. I appreciate it. I guess it is a good thing that I will be starting a course in mysql in a few weeks.. I am in dire need.
webdevoman
|