PDA

View Full Version : can i make self join table in mysql


seco
04-14-2007, 09:05 AM
Hi

i want to make self join table in mysql
how can i do that?

can i make relation between 2 table in phpmyadmin ?if not what is the tool for making that?

thanks in advance.

davidj
04-14-2007, 09:50 AM
perform your joins in your SQL statement

SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON TABLE2.FIELD = TABLE1.FIELD WHERE STUFF = VALUE

seco
04-14-2007, 10:33 AM
thanks for reply

just i have one table and i want to make self join on it

how can do that ?

thanks ..

davidj
04-14-2007, 10:35 AM
you only have 1 table

why would you need to do a join