Anyone here good with MS Access?

[wasssup]

I'm writing a simple SQL query for my database class, but I haven't been able to get the 'intersect' function to work...and after doing a bit of googling, i found out MS Access doesn't even support 'intersect'! (and we can only use access)...

is there any alternative?

 

[b4u]

What do you want to do?


(PS: This thread would be best answered if posted in the Programming forum - Can any Mod move it?)

 

[Gunslinger08]

JOIN

Look it up.

 

[Gunslinger08]

Probably an INNER JOIN at that.

 

[wasssup]

ahh...i ended up getting it to work with by defining the tables twice with two variables, and checking at the end to see if they exist in both. Guess i'll read up on the 'join' and 'inner join' features...and i'll make a new thread in the Programming forum

thanks for the help