duplicate query

[estersita]

Hello,

I submitted an SQL query in order to find members with the same Member ID and different Source field value .
In order to do it I created a copy of Flue_2003 and named it FluNODupl.

My query looks like the following:

SELECT [FLUE_2003].[MEMBER ID],[FLU_2003].[SOURCE],[FLUNODUPL].[MEMBER ID],[FLUNODUPL].[SOURCE]
FROM FLU_2003, FLUNODUPL
WHERE [FLUE_2003].[MEMBER ID]=[FLUNODUPL].[MEMBER ID] AND
[FLU_2003].[SOURCE]<>[FLUNODUPL].[SOURCE];

I did not get any error message about wrong syntax. However it looks like my query failed...

Could you please tell me what I did wrong?

Thank you!

Estersita

 

[PHV]

However it looks like my query failed...
What is wrong for you ? Unexpected result ?
Please elaborate.
If the 2 tables are identical then this query returns nothing.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[estersita]

PHV,

After I create my query , assign the name and run, it doesn't show me any results although it looks like it is generated as an object in DB. When I am trying to double click on it, it requests a parameter (I happened to get this kind of prompt before when smth was wrong).

I definetely know that there are at least a couple of records in both tables that contain identical Member ID and diffrent Source foelds' value.

Thanks,

Estersita

 

[PHV]

it requests a parameter
And what is the exact spelling of the popup prompt ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[estersita]

Sorry about this confusion. I have just found out that I misspelled the name of the table once and that is why I got that message

Thank you!