Page 1 of 1

About joins

Posted: Sun Nov 13, 2005 3:33 am
by rami
i have known some joins for database
currently i am using cross join as it is easy ..i have read almost all the database book says that dont use cross join
so what may be problem while using cross join...

i think access speed is not much problem as there will be some 1000 data only

the these joins also takes hard disk spaces

which join is best
i was feeling hard to write ineer join for three tables

what is problem using cross join
any help


can some body move this post the database section i think i have posted it in wrong section
sorry
no answer
thanks

Posted: Thu Nov 17, 2005 1:28 am
by RobertGonzalez
Why not use a straight or inner/outer join? It just seems easier to do.