Linking queries

[anemoskkk]

The two above are the ones I need to join into 1 query...
I tried to do this, but I get a syntax error:

[orange]

Perhaps you should tell us in your own words what it is that you are trying to accomplish. Maybe there are alternatives.

[anemoskkk]

Perhaps you should tell us in your own words what it is that you are trying to accomplish. Maybe there are alternatives.

OK

Well I have these tables:

[anemoskkk]

Any help would be greatly appreciated!

[June7]

Cross post at http://forums.aspfree.com/microsoft-...es-435597.html

[ajetrumpet]

Cross post at http://forums.aspfree.com/microsoft-...es-435597.html

If you're going to continue to do this, ask Matrix if you can be a moderator. Quit wasting space telling us this stuff. Everyone who wants something for free participates in cross posting.

If you keep doing it, I'm probably going to report you to the admin. And if this stuff is automated, it'll obviously be reported.

Thanks!

[June7]

I did not report the thread to moderator. I provided that link because the other thread has replies that might be informative to viewers here and I don't want to repeat the info in this thread. Would welcome moderator view on this. If they don't like it I certainly won't do it.