About joins

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rami
Forum Contributor
Posts: 217
Joined: Thu Sep 15, 2005 8:55 am

About joins

Post 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
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Why not use a straight or inner/outer join? It just seems easier to do.
Post Reply