Query issues due to a bad relationship!

[annemrosenberg]

Hi There!

I have a new dilemma for somebody to solve.

I have two tables.



The first table (EDC Archive) houses all of the images available from a source.

The second table (MDA Database) houses all of the images we have in house.

I need to create a query that will show which images in the EDC Archive are images we have in the MDA Database.

Once I've got that, then I need to be able to display some additional fields that are already in the EDC Database.

Since there weren't any unique fields in either table, i created an auto number field for both and made them the primary keys.

I then made a junction table and joined them together but its showing that they are only one-to-one relationships.


Does anyone have any insight as to how I can achieve this?

Thanks,
Anne

[ajetrumpet]

I need to create a query that will show which images in the EDC Archive are images we have in the MDA Database.

use a simple 'IN' subquery to get it.

something like:

select RECORDS from table1 where UNIQUE_COMBO_OF_FIELDS in (

select UNIQUE_COMBO_OF_FIELDS from table2)

I have a new dilemma for somebody to solve.

Unfortunately, we're not hear to solve dilemmas, girly. (that was 'partially' in fun)

[annemrosenberg]

Even without them being related?

[ajetrumpet]

Even without them being related?

the purpose of subqueries is the ability to do things that relationships and joins won't do (or when you don't have them).

furthermore, just because you don't have relationships set up as permanent structures, you can ALWAYS write them into queries when you create them. Just write the join statements yourself.

also, see my prev. post again. I added sql to it.

[annemrosenberg]

I write the subquery in the criteria row of the designer right?

[annemrosenberg]

Do you see the problem or problems?

[ajetrumpet]

look at your image dimensions, girly. it's unreadable. the pixellation is too small.

[annemrosenberg]

oh well...in any case its saying my syntax is wrong...

[annemrosenberg]

Am I even on the right path?? I'm so lost.

[ajetrumpet]

Have 2 things to say here:

1) If you post "I suck" one more time, I won't help you anymore because that's just the kind of attitude that's brought the USA to the place that it is now. and
2) the picture is STILL too bleak. I can't see it. It might be your computer's res. check it. It looks like it's the highest possible. That's not good for snapping a screenshot with print screen.

why not just upload the file and I'll help you out? tell me what tables you want to work with...

[annemrosenberg]

1. I promise not to say anything even remotely close to "I suck" , if you never call me "girly" again. deal? haha :-)

2. Good Idea! I have attached the file so you can see what kind of mess I've gotten myself into!

[annemrosenberg]

The file is 500,00KB it won't let me send it.

[ajetrumpet]

The file is 500,00KB it won't let me send it.

500000K is 500 mb. compact it, zip it, and if it's still too big, sh**can everything except the 2 tables you want me to show you how to manipulate.

ok? that'll be fine. surely the tables aren't bigger than 10MB combined. You'd need millions of records for that!

[ajetrumpet]

hey girl,

If you can't get it down below the max allowed here, you can email it to me if you wish. I think gmail's servers allow up to 10MB of filesize. It might even allow a lot more, but not sure.

Let me know if you want my address.

[annemrosenberg]

Yes! I would love to have your email so i can send the file...