1 Topic by F.M

  • F.M
  • Member
  • Offline
  • From: Kenya
  • Registered: 2007-01-22
  • Posts: 52

Topic: How do i link two table sin a dbase using mysql

How do i link two table sin a dbase using mysql?

  • Registered: 2004-05-24
  • Posts: 449

Re: How do i link two table sin a dbase using mysql

I'm not sure of what you mean but perhaps you're looking for this.

3 Reply by thegleek (edited by thegleek 2007-02-19 17:13)

  • From: Detroit, MI USA
  • Registered: 2006-08-11
  • Posts: 80

Re: How do i link two table sin a dbase using mysql

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.

~thegleek

thegleek's Website