can i make self join table

Wrox Programmer Forums

		Wrox Programmer Forums > PHP/MySQL > MySQL
can i make self join table

MySQL General discussion about the MySQL database.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

April 14th, 2007, 04:04 AM

seco

seco is offline

Authorized User

Join Date: Apr 2007

Posts: 10

Thanks: 0

Thanked 0 Times in 0 Posts

Default

can i make self join table

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.

Old

April 18th, 2007, 11:17 PM

surendran

surendran is offline

Friend of Wrox

Join Date: Oct 2003

Posts: 479

Thanks: 0

Thanked 3 Times in 3 Posts

Send a message via MSN to surendran

Send a message via Yahoo to surendran

Default

hi seco,
you cab simplly join.
select * from tbl1,tbl2 where tbl.fld1=tbl2.fld2

you can use sqlyog Enterprise Edition(www.webyog.com)

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
table join	debbiecoates	SQL Server 2000	2	July 2nd, 2008 01:39 PM
Can a Make Table Query produce a Linked table?	kronik	Access	5	May 16th, 2006 06:17 AM
Make Table query : table in Another Database	marnik	Access	1	March 19th, 2005 12:39 PM
could i join function(return table) with a table	alyeng2000	SQL Server 2000	6	September 30th, 2004 07:23 AM
outer join on same table	roog	SQL Language	4	September 30th, 2004 05:31 AM