<![CDATA[PunBB Forums — How do i link two table sin a dbase using mysql]]> https://punbb.informer.com/forums/topic/14875/how-do-i-link-two-table-sin-a-dbase-using-mysql/ Mon, 19 Feb 2007 17:11:57 +0000 PunBB <![CDATA[Re: How do i link two table sin a dbase using mysql]]> https://punbb.informer.com/forums/post/87779/#p87779 yes join, but join can be a complex subject in the sql world... here's the easiest way to do a join with 2 tables:

SELECT U.ID, U.USERNAME, Q.FAVQUOTE FROM USERS U INNER JOIN QUOTES Q ON U.ID = Q.ID WHERE Q.FAVQUOTE != NULL;

now MIND you, thats only an EXAMPLE.. but the basis is there.

]]> Mon, 19 Feb 2007 17:11:57 +0000 https://punbb.informer.com/forums/post/87779/#p87779 <![CDATA[Re: How do i link two table sin a dbase using mysql]]> https://punbb.informer.com/forums/post/87739/#p87739 I'm not sure of what you mean but perhaps you're looking for this.

]]> Mon, 19 Feb 2007 12:09:36 +0000 https://punbb.informer.com/forums/post/87739/#p87739 <![CDATA[How do i link two table sin a dbase using mysql]]> https://punbb.informer.com/forums/post/87737/#p87737 How do i link two table sin a dbase using mysql?

]]> Mon, 19 Feb 2007 11:47:39 +0000 https://punbb.informer.com/forums/post/87737/#p87737