Jump to content


Photo

Help with Mysql Join


  • Please log in to reply
1 reply to this topic

#1 carlg

carlg
  • Members
  • PipPipPip
  • Advanced Member
  • 104 posts
  • LocationPA

Posted 01 August 2006 - 10:06 PM

This is what I would write with Informix or most other DBMS's

select a, b, c, d, e, f
from t1, t2, outer t3
where t1.id=t2.id
and t2.id=t3.id

How would this query be written in mysql?

Thanks for the info

Carl



#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 August 2006 - 02:43 PM

Which table are these columns from?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users