how to compare two set of elements in sql query?

Question

I am working on "searching" in my project.I am using left join.At one situation i am getting infinite results becoz ,ex: if a user has 10 education details then i will get 10 times that same userid and when i add another employ ment details table and he has 10 employe ment details then my sql will show 100(10*10 =) same user id's when i join other tables it will increasing exponentially so I want one user id if he has 10 education details .for that i want to match set of array with array .OR let me no is there any alternative way to write that search query.Pls tell me........

Answer 1

A bit more detail as to your table structure and query syntax would help. Feel free to drop me a line with particulars and I'll see what I can do...frankly, I can't make heads or tails of your question.

Answer 2

It relies upon on the style you're development the question. i'm no longer an sq. jockey so I generally use OO3.a million Base layout View. There are field opt for and style suggestions that enable me a quite severe degree of specificity in development queries. you certainly would desire to get those extra effective fields out of there to diminish down you're loading situations.

Answer 3

when results replicate ur missing a join or where clause (depending on ur SQL statement)



also not sure if i read that right but u've got ur employment details in the same table as users??? :S