By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

SQL Query - redo needed

P: 39
I created these two queries with the help of the access query tool I know access does like a full outer joins. I need to be able to put this into a SQL line in an ASP page. (Didn't know if this would be the web developers forum or not)

Here are the two queries.
SELECT users.username, STATS06.*
FROM STATS06 INNER JOIN users ON STATS06.userid = users.id
WHERE (((users.username)='KLewis'));

Second one:
SELECT FISCALMONTH.id, [Get Stats].*, FISCALMONTH.qtr_year
FROM FISCALMONTH LEFT JOIN [Get Stats] ON FISCALMONTH.id=[Get Stats].fmid
WHERE (((FISCALMONTH.qtr_year)='4th Qtr FY-06'));

I've been working on this for a day and haven't come up with anything that works. Is this join possiable in one statement? Help needed!!! Thanks in advance.
-Will
Oct 17 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.