MS-ACCESS memo fields

[Swathi37]

Hello,

I have a serious problem linking 2 memo fields. I need some help. I have 2 tables say A and B. Table A has unique URLs and table B has URLS with duplicates. I need to find the count on matches and non matches.

The following query gives the result for count of matches.

SELECT A.URL, COUNT(B.URL) AS TEMP
FROM A, B
WHERE A.URL=B.URL
GROUP BY A.URL;

The above query gives me only those URLs which matches. I had to use where condition because Left Join did not work.

I would like to know how to find the count of non-matches for URLs. Is this possible with memo fields?

Thanks a lot in advance

 

[Prasad678]

Hi,
Didn't get U.
Count(Match) & Count(Non-Match). Is that what u want? Any more columns?

Prasad.

 

[Swathi37]

Thanks for your response Prasad.
For ex:

Table A
----------
/abc/
/abc/xyz
/pqr/
/aaa/ccc/ddd/

Table B
----------
/abc/
/abc/
/pqr/
/abc/
/pqr/
/xyz/

Output should be
----------------

URL Count
-------------------------
/abc/ 3
/pqr/ 2
/abc/xyz 0
/aaa/ccc/ddd/ 0

How do I get this? Infact from the above query I have mentioned I get only the first 2 rows.
Your help is greatly appreciated.

 

[Prasad678]

Hi,

Try this, this was working for me..

SELECT T1.URL, COUNT(T2.URL) AS TEMP
FROM T1, T2
WHERE T2.URL (+)= T1.URL GROUP BY T1.URL


Just an Outer Join.

Thanx,
Prasad.